Just to say, it does about everything I would ask. Here I rewrote it without using ASCII codes (same number of lines really, but now I see "-" and "." in code ;) ) (Oh. And it uses GOTO as CONTINUE statement ;) ) function num$(d$) t = 0 for i=1 to len(d$) a$=mid$(d$,i,1) if a$=&q...
I'm afraid that couldn't be done quite right. Do we have caret position (insertion point)? If not, how program could tell which dot is old and which new? Without that we only could remove one dot - first or last positionally, arbitrary choice to be made And insertion point will move to the end of cu...
There are members of the LBB forum who are moderators on the LB Forum. Perhaps they would like to explain why I have been banned. (Here my view what happened, may be not 100% accurate, not official statement anyway) Current policy - more or less - is that mentioning LBB is prohibited. You have been...
I'm still puzzled by this code. What does "a=8" do? Just clears that code, in effect removing character? So almost anything besides 8 will do? (last line in effect allows only ".","-" and digits - so using anything else instead of 8 will do the same) Now, t1 is not used...
about leading '0' and trailing '.'
I think it makes sense to fix on leaving the cell.
I don't know how this event could be hooked - but at least there is a way to check if cell has focus or not.
So if it doesn't have focus you can do extra check and change say '0025.' to '25' or '25.0'.
Trying to debug code from Formatting Numeric Input thread, I found that program in LB breaks after handling first event while in LBB it works OK. The problem code was function with WAIT inside Here's the code I came up with. My guess that in JB/LB after WAIT program waits on the spot it happened. Th...
Hello RNBW I would say your code shows that could be done - and it's a good thing But it really could be worked on to be used. Taking last code: * it checks numbers twice. Why it uses FOR by row? * 2e3 barks as invalid, but then converts to 2000 as should be * 2a3 barks as invalid but converts to 2 ...