does textbox contain a number

  • Thread starter Thread starter Spencer Hutton
  • Start date Start date
S

Spencer Hutton

i need a statement that can evaluate whether or not a text box's value/text
is a number or not?
TIA
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Improving Nested Formula Calculation Efficiency 2
Need help converting number string to number 3
Ensure cell contains a number 2
How to subtract a number from a Mergefield? 0
Linking textboxes with option boxes 4
select all cell containing any formula and not text or number 2
Number stored as text 4
Excel Sum numbers in cells that also contain text 34

Back
Top