required field

Wrecker · Mar 6th, 2002, 08:02 AM

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

Thanks in Adcance
Wrecker

dk · Mar 6th, 2002, 08:11 AM

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

Code:

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 · Mar 6th, 2002, 08:24 AM

Got it.... Thanks

Wrecker

Mar 6th, 2002, 08:11 AM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	You can use the textbox's Exit event e.g. Code: 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 6th, 2002, 08:02 AM	#1
Wrecker New Member Join Date: Mar 2002 Posts: 13	Is there a way to make nformation in a textbox on a userform required? Thanks in Adcance Wrecker

Mar 6th, 2002, 08:24 AM	#3
Wrecker New Member Join Date: Mar 2002 Posts: 13	Got it.... Thanks Wrecker