I have created a text book and need the user to input in a certain way: a letter, number followed by 3 letters.
In VB 6, I know the mask edit control does this but I can't find it in VBA?
Is there any other way I can validate the users input?
:)
Printable View
I have created a text book and need the user to input in a certain way: a letter, number followed by 3 letters.
In VB 6, I know the mask edit control does this but I can't find it in VBA?
Is there any other way I can validate the users input?
:)
You can use the KeyDown event to validate the key presses or the Change event to
validate the entire content.