Excel VBA: clicking a radio button by VBA
I have a set of option buttons on the worksheet (not a form), linked to a cell. My code often changes the contents of the cell directly, but the option buttons don't change to reflect it.
All the suggestions I've seen involve code in the WorksheetChange event, but there's an awful lot going on there already. (For one thing, there are times when EnableEvents is disabled.) Besides which, I have two different worksheets with the same issue, so I'd prefer to use a macro in a module rather than in two different Events.
I know that in a macro, the option button is called something like CurSheet.OLEObjects("OptionButton1"), but I can't figure out how to click it.
(If I do have to use an Event, what can I use other than Worksheet Change?)
The buttons are OLEObjects (that means ActiveX, not form controls, right?).