Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update option button from c#
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update option button from c#
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update option button from c#
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Option Button | Excel Worksheet Functions | |||
keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
Option Button | Excel Discussion (Misc queries) | |||
Option Button Value | Excel Programming | |||
Find and read/update option button | Excel Programming |