Check userform values

[robfo0]

Hi,

Is there a quick code that i can use to make sure that a value in a text box on my userform is a number (0-9), and if its not, give a message or something?

Thanks

 

[Al Chara]

Try the following code:

If Application.WorksheetFunction.And(textbox1.Value >= 0, textbox1.Value <= 9) = False Then MsgBox "Incorrect value"

Replace textbox1 with the name of your textbox.

 

[robfo0]

Al, thanks for the quick response, but actually I worded my question wrong. I want the value to be a number, but it may have multiple digits...so it could be 12345 etc. I'm just trying to keep everying except numbers out of the field. How would i do that? thanks Al

 

[NateO]

If Not Application.WorksheetFunction.IsNumber(textbox1.Value) _
Then MsgBox "Make it a number please. Merci."


_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue">O</font></font></font>
This message was edited by NateO on 2002-04-02 15:41

 

[robfo0]

Thank you very much