View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marty Marty is offline
external usenet poster
 
Posts: 116
Default 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