Update option button from c#

  • Thread starter Thread starter Lee
  • Start date Start date
L

Lee

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Option Buttons and Combo Bars 7
Change Header/Footer w/ Worksheet Option Buttons 1
How to call Excel add-in macro from a button… 1
Buttons not always moving deleting rows. Odd behavior 4
My Excel Options button is greyed out (Excel 2007) How to turn it 1
Radio Button Selection on Auto Open 4
Where have my macro links gone? 2
macro using forms button 1

Back
Top