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

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

Could there be 7digits and an alpha?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Frank Kabel" wrote in message
...
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