I Team,
I need help with code for an excel macro, which sends users to another sheet in an excel table once a checkbox is checked, but does nothing if it is unchecked.
I tried this already, but no luck:
<code>Sub CheckBox28_Click()
If OptionButton1 = True Then
Sheets("Sheet3!A1").Select
ElseIf OptionButton1 = False Then
End If
End Sub</code> It compiles, but nothing happens when the macro is assigned to the checkbox
Please, help
I need help with code for an excel macro, which sends users to another sheet in an excel table once a checkbox is checked, but does nothing if it is unchecked.
I tried this already, but no luck:
<code>Sub CheckBox28_Click()
If OptionButton1 = True Then
Sheets("Sheet3!A1").Select
ElseIf OptionButton1 = False Then
End If
End Sub</code> It compiles, but nothing happens when the macro is assigned to the checkbox
Please, help