i have option buttons 1 and 2 inside a group box
I need: if option button 1 is true, then option button 3 is visible. If option button 2 is true, then option button 3 is hidden.
I tried this code but i dont remember vba much
Sub OptionButton1_Click()
If OptionButton1.Value = True Then
Shapes("Option Button 3").Visible = True
ElseIf OptionButton1.Value = False Then
Shapes("Option Button 3").Visible = False
End If
End Sub
any help would be greatly appreciated
Bookmarks