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