conditional validation

[TUNGANA KURMA RAJU]

How to codify the following logic:
A textbox in a userform can be left blank without entering any
data/value.But if entry is needed only numeric values(numbers with or without
decimals) be entered.
Msg. be fired the moment it finds a text character.Example:Textbox Entry='R'
or
'123h'.cursor should not move from the textbox until
correction/rectification done by user.
While rectification if user deletes whole entry and leave the textbox blank,or
corrects the entry by putting only numeric values.

 

[booklady]

How to codify the following logic:
A textbox in a userform can be left blank without entering any
data/value.But if entry is needed only numeric values(numbers with or without
decimals) be entered.
Msg. be fired the moment it finds a text character.Example:Textbox Entry='R'
or
'123h'.cursor should not move from the textbox until
correction/rectification done by user.
While rectification if user deletes whole entry and leave the textbox blank,or
corrects the entry by putting only numeric values.

 

[booklady]

When I am working on my worksheet, I keep getting fixed decimals in my
numbers. I do not want decimals. I have tried to change it in my dialog
box, but it keeps coming back. I have tried closing the worksheet out and
starting a new one, but I have the same result. What gives?