Determining what object was clicked.

[foxguy]

I assign the same macro to all my ToggleButtons, and use Application.Caller to determine which button was clicked.

Please Login or Register  to view this content.

I also do the same thing for CheckBoxes, but using this code

Please Login or Register  to view this content.

I would like to do the same thing for OptionButtons, but I can't figure out what to put here:

Please Login or Register  to view this content.

"s" has the name of the OptionButon in it, but I can't get it into an object.
"OptionButtons(s)" doesn't work and neither does "Shapes(s)".
How can I get the OptionButton object?

I know that I could probably cycle through all the shapes on the worksheet looking for the one with that name, but I would rather go directly.

[romperstomper]

OptionButtons is the correct collection (assuming you used Forms controls)

[foxguy]

romperstomper;
I just discovered my problem. I had the option buttons grouped, so even though I had the individual button name, there is no ActiveSheet.OptionButtons(<button name>), it's inside a group collection.

Do you know how I can get the option button into an object when it's grouped?

[romperstomper]

In 2007 it should work whether grouped or not, I think. For earlier versions I think you will need to loop through the shapes, check the type (if it's 6, it's a group) and then iterate the groupitems and check the name.

[foxguy]

It's not working in my version of 2007.

I'm now developing code to cycle through all the shapes looking for groups to cycle through. Glad to know I'm on the right track.