View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TUNGANA KURMA RAJU TUNGANA KURMA RAJU is offline
external usenet poster
 
Posts: 171
Default conditional validation

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.