7 Digits Only
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 |
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 |
7 Digits Only
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 |
All times are GMT +1. The time now is 10:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com