How2 accept only numbers in userform textbox
Hello:
I have a useform which requires a user to input data into some textboxes.
The user then clicks a button and some math is done on the data input by the
user.
The problem is that right now there is nothing to prevent the user from
putting anything (text, symbols or whatever) into the boxes, and this causes
a runtime error when the button is clicked.
I'm looking for some code to put into my userform which will generate an
error message if the user inputs anything other than a number into one of the
textboxes.
Help would be appreciated.
Thanks,
MARTY
|