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