VBA Data Validation for Userform Textbox

[Maryz]

I’m searching for VBA code to allow only numeric entry for certain text boxes in my userform with a warning message if anything except numbers are entered. I can’t seem to find it in the VBA help section.

Is there a section of the help function or any other resources that describes the various data validation that can be performed through VBA for userforms?

 

[Mark O'Brien]

Nope, there is no such section, you'll have to program it yourself. Or, even better, follow this link:

http://www.mrexcel.com/board/viewtopic.php?topic=1930&forum=2

I had to link to one of my own posts, I hope this doesn't seem conceited.

HTH

 

[Andrew Poulsom]

There is no built in validation. You will need to check what's entered via code, eg

Private Sub TextBox1_Change()
    Dim Char As String
    Char = Right(TextBox1.Text, 1)
    If Char Like "#" Then Exit Sub
    Beep
    On Error Resume Next
    TextBox1.Text = Left(TextBox1.Text, Len(TextBox1.Text) - 1)
    TextBox1.SelStart = Len(TextBox1.Text)
End Sub

 

[squeebles]

even though this post is almost 10 years old it still works and has helped me. thank you!