Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform; text restrictions
Hi, I'm working with a VBA userform; in the fields are only digits and letters allowed. How do I make this restriction? -- jgmiddel ------------------------------------------------------------------------ jgmiddel's Profile: http://www.excelforum.com/member.php...o&userid=32714 View this thread: http://www.excelforum.com/showthread...hreadid=527207 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform; text restrictions
There is no built in data validation capability. You would need to use code
to validate the data using the builtin events. If, by chance, you have a textbox with a finite list of acceptable entries, then you can replace that with a combobox. -- Regards, Tom Ogilvy "jgmiddel" wrote: Hi, I'm working with a VBA userform; in the fields are only digits and letters allowed. How do I make this restriction? -- jgmiddel ------------------------------------------------------------------------ jgmiddel's Profile: http://www.excelforum.com/member.php...o&userid=32714 View this thread: http://www.excelforum.com/showthread...hreadid=527207 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
RESTRICTIONS | Excel Discussion (Misc queries) | |||
Text Restrictions | Excel Worksheet Functions | |||
How to do look up with restrictions | Excel Discussion (Misc queries) | |||
Highlight certail text in a userform Text box | Excel Programming | |||
character restrictions when importing data from a text file | Excel Discussion (Misc queries) |