User Form Controls
You can use the keypress event to reject all but numbers and stop accepting
entries when the length more than 4.
--
Regards,
Tom Ogilvy
"Ben E" wrote in message
...
Hi all,
Is it possible within a excel user form to set a text box
to:
1) only accept numbers
2) only accept a set number of characters
Ie the user can only input a 4 number code.
Ben E
|