you should put any optionbuttons that belong to eachother in one containing
frame. Then you give them names that make sense.

you set it's value-property to true by:

OptionButton1.value = True


"Lee" wrote:

Hi,

I have a spreadsheet which contains several option buttons. Each
option button has a macro assigned.

I have a c# programme which uses the spreadsheet. I wish to simulate
the pressing of one of the option buttons. I have no problem running
whichever macro I need from my c# programme but I cannot find a way of
setting whichever option button.

Thanks
Lee