Hi there,
Sample Excel file: [ATTACH]n1224595[/ATTACH]
I'm new to VBA and am trying to get specific option buttons to autoselect based on the value a user selects for another option button. My code so far is copied below, however, it does not appear to be working. Would greatly appreciate any help!
Private Sub Worksheet_Change(ByVal Target As Range)
If ActiveSheet.OptionButton215.Value = xlOn Then
ActiveSheet.OptionButton231.Value = xlOn
Else
ActiveSheet.OptionButton231.Value = xlOff
End If
End Sub