Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks for your post, Kevin. Not sure how to implement
your suggestion. Even w/in an Excel module I don't know the syntax to reference a vba checkbox... or rather I can reference checkboxes... and obtain their value, I just don't know how to set the value of a specific checkbox. thnx again -----Original Message----- Try creating a macro as a standard module then run that module from your other application something like this: Application.Run "'" & ActiveWorkbook.Name & "'! module1.procedureName", param1, param2, etc. Kevin -----Original Message----- I have some vba checkboxes on a spreadsheet, and I want to be able to toggle them programmatically from another application. I have tried code like: XL.ActiveSheet.OLEObjects("CheckBox2").Object.Va lue = True but it doesn't work. What am I doing wrong? Thanks in advance. . . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Checkbox | Excel Discussion (Misc queries) | |||
How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) | |||
Checkbox | New Users to Excel | |||
Checkbox | Excel Discussion (Misc queries) | |||
checkbox | Excel Worksheet Functions |