How to set user's input in textbox to be numerical?

C

Chwa See Kiap

i have a Form with a TextBox for user's input.
Can i limit user's input so that only numerical input is acceptable?

THX.
 
A

arthurjr07

Private Sub Text1_KeyPress(KeyAscii As Integer)
If KeyAscii < 47 Or KeyAscii > 58 Then KeyAscii = 0
End Sub

HTH
 

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

Collect User Input 2
Non standard characters 3
Textbox Validation 6
Create Userform from Worksheet 8
Textbox value 2
switch automatically between text boxes 4
Validate userform textbox entry with Sheet range. 2
Set focus on controls of modeless form 4

Top