Thread: vba checkbox
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default vba checkbox

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.

.

.