| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CheckBoxes how to remember changes
I have some CheckBoxes and I would like to remember which CheckBox was pest
when I start the Excel Sheet again, but I always get empty CheckBoxes. How can I let the CheckBoxes know which one was selected. Many thanks in advance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CheckBoxes how to remember changes
Store the values in a hidden sheet would be my reccomendation. Each time a
change is made to the check boxes update the values in the hidden sheet. When you open the workbook use the on onen event in ThisWorkbook to initailize the check boxes. -- HTH... Jim Thomlinson "p. panter" wrote: I have some CheckBoxes and I would like to remember which CheckBox was pest when I start the Excel Sheet again, but I always get empty CheckBoxes. How can I let the CheckBoxes know which one was selected. Many thanks in advance. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CheckBoxes how to remember changes
Marty,
You can link the value of the checkboxes to a cell. When the Workbook Open event is kicked off, set the appropriate state for the checkboxes based on the related cell values. -- http://HelpExcel.com 1-888-INGENIO 1-888-464-3646 x0197758 "p. panter" wrote: I have some CheckBoxes and I would like to remember which CheckBox was pest when I start the Excel Sheet again, but I always get empty CheckBoxes. How can I let the CheckBoxes know which one was selected. Many thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I cannot remember... | Excel Discussion (Misc queries) | |||
| Can someone please help me to remember | New Users to Excel | |||
| I used to be able to do this, I can't remember how | Excel Discussion (Misc queries) | |||
| I can't remember how to... | Excel Programming | |||
| Remember and add | New Users to Excel | |||
Linear Mode
