Userform - Data Check

[mnmhenry]

My userform is progressing nicely now, thank you all for your help.

I would like to have some method of check system. ie - when I activate the Execute button, i get a message box saying " you have not entered data into TextBox3"

Kind of like a Reqired Data form that you cannot go past this stage without entering something in that textbox.

Also I have 10 TextBox I will want to use the check for (all on the same userform)

Thanks so much,
Mark

 

[Smitty]

You can start with something like this:

<font face=Calibri><SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> CommandButton1_Click()<br>    <SPAN style="color:#00007F">If</SPAN> LenB(TextBox3.Value) = 0 <SPAN style="color:#00007F">Then</SPAN><br>        MsgBox "Yo, you have to fill in yadayada..."<br>    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

If you have a lot of controls you can count them instead.

HTH,