Letters and numbers only
 

How do I make sure the user can only input letters and numbers? No
spaces or symbols?


--
xander1987
------------------------------------------------------------------------
xander1987's Profile: http://www.excelforum.com/member.php...o&userid=27236
View this thread: http://www.excelforum.com/showthread...hreadid=469527

Letters and numbers only
 

Input where? In a cell? In a textbox? If textbox, what kind of textbox
and where is it located?

If a cell, use the change event to examine what has been entered and react
accordingly.

--
Regards,
Tom Ogilvy

"xander1987" wrote
in message ...

How do I make sure the user can only input letters and numbers? No
spaces or symbols?


--
xander1987
------------------------------------------------------------------------
xander1987's Profile:
http://www.excelforum.com/member.php...o&userid=27236
View this thread: http://www.excelforum.com/showthread...hreadid=469527