7 Digits Only
Hi
in the Exit event of this textbox you could check for the length of the
textbox value. e.g.
'....
if len(textbox1.value)<7 then
msgbox "entry too short"
cancel=true
end if
'...
--
Regards
Frank Kabel
Frankfurt, Germany
gregork wrote:
I want to have a message box come up when there are less than seven
digits on a UserForm TextBox . How would the code go?
Greg
|