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

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

Many thanks
I realised that I could simply set the option button within the macro
hence when the macro is run the option button is set.
i.e.
ActiveSheet.OptionButtons(1).Value = True
Lee