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?

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
>
>