Limiting input type in a textbox....how?

[Simply Me]

You can also use Isnumeric() to limit the entry to numeric only

If IsNumeric(Text1.Text) = False Then
     MsgBox "Type numeric value", , "Result"
     Text1.SetFocus
     Exit Sub
End If

[I_Love_My_Vans]

Hang on, has no one thought of using the masked edit box? It acts just like a text box, and you can mask the input so it acts exactl how you wants it to.

Project > Components > Select "Microsoft Masked Edit Control 6.0" then click ok.

Then set the mask to 999999999