Allowing only 1 toggle button pushed out of 2 choices

[ahigh17]

My worksheet has toggle buttons that say "Yes" and "No" that turn the cell they're in green or red, respectively. Right now you can select both toggles and have both cells be colored in. I would like it so when "Yes" is clicked (and green), and someone clicks "No", the "Yes" toggle goes off (and back to white), and vice versa, so that only one can be selected at a time. Is this possible? here is the code I'm currently using for the "Yes" toggle. "No" is the same, only it's ("H13") -


Private Sub ToggleButton1_Click()

If ToggleButton1.Value = True Then
Range("G13").Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 5287936
.TintAndShade = 0
.PatternTintAndShade = 0
End With

Else
Range("G13").Select
With Selection.Interior
.Pattern = xlNone
.TintAndShade = 0
.PatternTintAndShade = 0
End With

End If
End Sub

[stnkynts]

Use the code to turn the other one off.

Please Login or Register  to view this content.

[ahigh17]

That was easy! Thank you sir!