Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to execute a macro assigned to a checkbox in vba
Hi,
For testing purposes i want to control a workbook from another workbook with vba. When setting a checkbox to 'checked', the macro assigned to the checkbox is not executed. the code i use is: Dim name As String Dim cbo As CheckBox name = "some value read from a cell' Set cbo = otherWorkbook.ActiveSheet.CheckBoxes(name) cbo.value = 1 'make checkbox 'checked' In similar code for buttons i use: Run button.OnAction, this does not work for a checkbox though. Also i can't get the name of the macro from the checkbox in vba. Does anyone know how i can get the macro assigned to a checkbox to execute from vba? Note that i don't know the macro name in the code, only the name of the checkbox. thanks Pieter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use Macro To Change Which Macro Assigned To Command Button | Excel Discussion (Misc queries) | |||
Macro assigned to a button | Excel Discussion (Misc queries) | |||
How do I know what macro is assigned to a button? | Excel Discussion (Misc queries) | |||
Which Macro Is Assigned to a Button | Excel Programming | |||
Buttons assigned to a macro | Excel Programming |