Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Form controls in Excel 07 | Excel Discussion (Misc queries) | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
User Form Controls | Excel Programming | |||
User Form Controls | Excel Programming | |||
user form controls | Excel Programming |