7 Digits Only

[gregork]

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

 

[Frank Kabel]

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
'...

 

[Bob Phillips]

Could there be 7digits and an alpha?

--

HTH

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