Hi,

Am Wed, 27 Jan 2021 06:50:07 -0800 (PST) schrieb programmernovice:

My active sheet has 2 buttons labeled "High" and "Low". Selection of one deselects the other. Can someone please suggest a VBA script that would be equivalent to clicking on one of the buttons?

try:

Private Sub CommandButton1_Click()
With CommandButton1
If .Caption = "High" Then
'do the stuff you want for button "High"
.Caption = "Low"
Else
'do the stuff you want for button "Low"
.Caption = "High"
End If
End With
End Sub


Regards
Claus B.
--
Windows10
Office 2016