Hello,
I keep getting the "object doesn't support this property or method" error for the code below and I can't figure out why. Any help is appreciated. Thanks.
Private Sub ComboBox1_Change()
If Range("u10") = "primary care clinic" Then
Worksheets("Step 2").TextBox23.Visible = False
Worksheets("Step 2").TextBox23.Value = ""
Worksheets("Step 2").TextBox22.Visible = False
Worksheets("Step 2").TextBox22.Value = ""
Else
Worksheets("Step 2").TextBox23.Visible = True
Worksheets("Step 2").TextBox22.Visible = True
If Range("u10") = "outpatient surgery clinic" Then
Worksheets("Step 2").TextBox23.Visible = False
Worksheets("Step 2").TextBox23.Value = ""
Else
Worksheets("Step 2").TextBox23.Visible = True
End If
End If
End Sub
Bookmarks