On Wednesday, January 27, 2021 at 10:41:36 AM UTC-6, Claus Busch wrote:
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
Greatly appreciate your help, Claus!