VBA Script for Radio Button
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
|