Select option button if text present

[ipbr21054]

Hi,
Please can you advise how optionButton1 can be automatically selected if text is present in TextBox4
No text then no selection

Thanks

 

[kevin9999]

Do you mean set optionButton1 to True if there's a change in Textbox4 AND Textbox4 isn't blank? If that's what you mean, try this code the Textbox4.

Private Sub TextBox4_Change()
    If TextBox4 <> "" Then
        If OptionButton1.Value <> True Then OptionButton1.Value = True
    Else
        OptionButton1.Value = False
    End If
End Sub