manipulating Excel checkbox from VB based exe

[Mark]

I have a VB program that collects data and then modifies an existing
spreadsheet. My VB program can easily modify the text cells in my
spreadsheet but I can not figure out how to have my VB program modify
checkboxes (form type checkbox) on the same spreadsheet.

TIA

Mark

 

[John Green]

Mark,

You should be able to address the checkbox as a member of the worksheets
CheckBox collection. Something like:

xlApp.Workbooks(1).Worksheets(1).CheckBoxes(1).Value = True

 

[Gary Misner]

Mark,

If your stuck with using a Form then Link the form to an unused cell. then
manipulate the Cell.
This can be accomplished through the form Controls dialog on the Controls
tab.


If your doing a lot of this you may want to investigate using the checkbox
from the Control Tools menu instead of the forms menu. The Control tools
can be named and more easily accessed from the program.


Good Luck,
Gary M.


Another alternative is to