Thread: 7 Digits Only
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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