TextBox Validation

markoakes

Active Member
Joined
Jan 5, 2004
Messages
325
I have a textbox on a userform that I would like to only allow numbers to be entered. How do I set up Validation for numbers only?
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

kskinne

Well-known Member
Joined
Feb 17, 2002
Messages
1,267
Office Version
  1. 365
Platform
  1. Windows
something along these lines would work:

Code:
Private Sub TextBox1_AfterUpdate()
If TextBox1.Value = "" Then Exit Sub
Select Case IsNumeric(TextBox1.Value)
    Case True
    MsgBox "OK"
    Case False
    MsgBox "Not OK"
    Case Else
End Select
End Sub

just customize it to suit your needs on what you want to happen when the condition is met or not met


hth
kevin
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
60,886
Office Version
  1. 365
Platform
  1. Windows
Here is another way. I usually put a command button on my form, that when clicked will go through and verify all entries. So if we just have a command button and a text box on the form, the code would look something like:

Code:
Private Sub CommandButton1_Click()
    
    If Not IsNumeric(TextBox1) Then
        MsgBox "Only numbers may be entered in the text box"
        TextBox1.Value = ""
    End If

End Sub
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,160
Messages
5,768,537
Members
425,480
Latest member
br400821

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top