Validation for numeric values 1

[Syerston]

What is the syntax for validating for numeric only values in a text box.

Many thanks John

 

[jebry]

Hi John!

Try this:

If Isnumeric(YourTextBox) = False Then
Call MsgBox("You must input numbers only&quot
End If

You might want to trim the entry before testing it.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[Syerston]

Thanks Jeff

Fantastic.

Just a quick question. Why would I want to Trim it. John

 

[jebry]

Hi again!

Trimming will get rid of spaces from the start and end of the input string which the user may accidently add. In fact I'm not sure that such spaces will affect the IsNumeric function or not. Some programmers trim input strings just to avoid any possible misunderstandings they may generate in VBA.

hth
Jeff Bridgham
bridgham@purdue.edu