required field

[Wrecker]

Is there a way to make nformation in a textbox on a userform required?

Thanks in Adcance
Wrecker

 

[dk]

You can use the textbox's Exit event e.g.

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If Me.TextBox1.Text = "" Then
    MsgBox "You must add a value to Textbox1"
    Cancel = True
End If
End Sub

HTH,
D

 

[Wrecker]

Got it.... Thanks

Wrecker