if a checkbox is selected a texbox is required to be populated

[patteb]

I have a userform created and i am looking to make a textbox a required field if a checkbox is selected. if the textbox is not seslect before sunmitting then a msg box will apear. how can this be done?

 

[steve the fish]

Hi. Im not sure what you want to use as a trigger (eg command button) but something like this:

If CheckBox1.Value = True Then
    If Len(TextBox1.Value) = 0 Then
        MsgBox "Please fill in textbox!"
        TextBox1.SetFocus
        Exit Sub
    End If
End If

 

[patteb]

Hi. Im not sure what you want to use as a trigger (eg command button) but something like this:

If CheckBox1.Value = True Then
    If Len(TextBox1.Value) = 0 Then
        MsgBox "Please fill in textbox!"
        TextBox1.SetFocus
        Exit Sub
    End If
End If

Thank you, i have got it working with you help.