manipulating Excel checkbox from VB based exe
 

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

manipulating Excel checkbox from VB based exe
 

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).Val ue = True



--
John Green
Sydney
Australia


"Mark" wrote in message
m...
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

manipulating Excel checkbox from VB based exe
 

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
"Mark" wrote in message
m...
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