option button?
 

i have an option button on sheet1 that was created
with the forms toolbar.

how do i toggle the state of button the from within a macro.

(the option button name is "Option Button 57")

option button?
 

Hi Pete,

Try:

Sub AAA()
With ActiveSheet.OptionButtons("Option Button 57")
If .Value = xlOn Then
.Value = xlOff
Else
.Value = xlOn
End If
End With
End Sub



---
Regards,
Norman



"Pete" wrote in message
...
i have an option button on sheet1 that was created
with the forms toolbar.

how do i toggle the state of button the from within a macro.

(the option button name is "Option Button 57")

option button?
 

Hi Pete,

Or, more concisely,

Sub AAA2()
With ActiveSheet.OptionButtons("Option Button 57")
.Value = Not .Value = xlOn
End With
End Sub

---
Regards,
Norman



"Norman Jones" wrote in message
...
Hi Pete,

Try:

Sub AAA()
With ActiveSheet.OptionButtons("Option Button 57")
If .Value = xlOn Then
.Value = xlOff
Else
.Value = xlOn
End If
End With
End Sub



---
Regards,
Norman



"Pete" wrote in message
...
i have an option button on sheet1 that was created
with the forms toolbar.

how do i toggle the state of button the from within a macro.

(the option button name is "Option Button 57")