Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with function to add percentage to cell based on checkbox. | Excel Worksheet Functions | |||
Manipulating a checkbox by name dynamically | Excel Programming | |||
Manipulating a checkbox by name dynamically | Excel Programming | |||
Conditional Button Enabling based on Checkbox | Excel Programming | |||
Button Enabling based on check in checkbox | Excel Programming |