The "optionbuttons(1)" refers to the first (earliest created)
option button on the sheet. Alternatively, you can use the name
of the option button. E.g.,

Debug.Print ActiveSheet.OptionButtons("TheButton").Value


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"crapit" wrote in message
...
I'm using forms toolbar. Does the "optionsbutton(1)" refer to
the name of
the optionbutton or something else?
"Chip Pearson" wrote in message
...
If the button is from the Forms toolbar, use code like

Debug.Print ActiveSheet.OptionButtons(1).Value

If the button is from the Controls toolbar, use code like

Debug.Print
ActiveSheet.OLEObjects("OptionButton1").Object.Val ue


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"crapit" wrote in message
...
I have 2 option button. How do I get the state of the
option
button? (The
optionbutton is not on the userform)