topic Re: in VBA Forum

TextBox control question

Anonymous — Mon, 07 Aug 2000 16:06:35 GMT

Hey guys - I have a question here regarding TextBox User Imput control.
I want to add code that will not allow the user to finish the UserForm unless there are at least 4 digits
in the TextBox. I know how to limit them to 4 digits but I need a way to send a msgbox and stop them
if they attempt to put in less than 4.
Any suggestions?
Blaine Loyd

Re: TextBox control question

Anonymous — Mon, 07 Aug 2000 17:38:39 GMT

Hi Blaine,
How about adding something to the effect of the following to your "OK" button:
if len(TextBox.Text) < 4 then
MsgBox "You Need at Leats 4 Characters"
else
me.hide
'do your stuff
end if

-Josh

blaine23 wrote:

> Hey guys - I have a question here regarding TextBox User Imput control.
> I want to add code that will not allow the user to finish the UserForm unless there are at least 4 digits
> in the TextBox. I know how to limit them to 4 digits but I need a way to send a msgbox and stop them
> if they attempt to put in less than 4.
> Any suggestions?
> Blaine Loyd

Re:

Anonymous — Mon, 07 Aug 2000 17:39:45 GMT

Excuse the typo, that should be "at Least 4 Characters." 🙂

Re:

Anonymous — Mon, 07 Aug 2000 18:53:46 GMT

Hey Josh-
That code worked great. Appreciate the help very much.
Blaine Loyd