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

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