Thread: Numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jevul Jevul is offline
external usenet poster
 
Posts: 2
Default Numbers

Hello,

I am trying to figure out a way to prevent users from
entering a "not real" number into a text box. I tried to
ues an If statement.... If Not Isnumeric......
This doesn't seem to work. I had a user input "2345.45-"
with no error but excel igneroed the number in a
calculation. My users are bound to make many mistakes
and I would like to catch them at the time.

Thanks