C Choong New Member Jun 17, 2016 #1 Can we control the userform textbox input to alphanumeric whereby the first is alphabet and follow by 9 digits. Example : A12345678 The length of the input should be 9. Not allowed to enter symbol and prompt an error message if enter invalid value.
Can we control the userform textbox input to alphanumeric whereby the first is alphabet and follow by 9 digits. Example : A12345678 The length of the input should be 9. Not allowed to enter symbol and prompt an error message if enter invalid value.
N NARAYANK991 Excel Ninja Jun 18, 2016 #2 Hi , See if this helps : http://stackoverflow.com/questions/24889340/validating-the-format-of-a-userform-textbox-entry Narayan
Hi , See if this helps : http://stackoverflow.com/questions/24889340/validating-the-format-of-a-userform-textbox-entry Narayan
