Validating that a UserForm TextBox is not left empty

[ronnie76]

I have a user form in which 4 of the 12 Text boxes need to filled in.
Is there a way without using command button to validate that those text boxes have information in them?

Thanks for the help

 

[iggydarsa]

maybe this can give you an idea

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If TextBox1.Value = "" Then
    MsgBox "you left it empty"
End If
End Sub

when the user enters the textbox and leaves the textbox without entering any data a msg will popup...

if you dont want the user to be able to move on you have to do some type of error checking at the button click event

 

[ronnie76]

Works perfect! Thanks a million.

One other question though how does the (ByVal Cancel As MSForms.ReturnBoolean) make the code work?


Thanks again.

 

[Norie]

Actually the Cancel isn't being used in the posted code.

To use it add this.

Cancel = True

What this does is 'cancel' the exit from the control.