Spencer,

You can use the IsNumeric function to test whether a text string
is numeric.E.g.,

If IsNumeric(Me.TextBox1.Text) = True Then
' is a number
Else
' not a number
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"Spencer Hutton" wrote in message
...
i need a statement that can evaluate whether or not a text
box's value/text
is a number or not?
TIA