Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Auto-checking a checkbox based on cell contents.
Is it possible to set or "check" a checkbox in real time, based on the
contents of a cell? I know the cell link field can tie a cell to a check box, but (if I understand it right) it's a one way link (meaning the cell reacts to the check box). Any help would be appreciated. Thanks, Ramon |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Auto-checking a checkbox based on cell contents.
Hi Ramon
this would require VBA using an event procedure like worksheet_change -- Regards Frank Kabel Frankfurt, Germany "Ramon Cantu Jr." schrieb im Newsbeitrag om... Is it possible to set or "check" a checkbox in real time, based on the contents of a cell? I know the cell link field can tie a cell to a check box, but (if I understand it right) it's a one way link (meaning the cell reacts to the check box). Any help would be appreciated. Thanks, Ramon |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Auto-checking a checkbox based on cell contents.
If you link a cell to the checkbox (either from the Forms toolbar or the control
toolbox toolbar), then you can change that cell (true/false or 1/0) and the checkbox will update. But you can't have a formula in that linked cell if you're going to click on the checkbox. It'll be overwritten. "Ramon Cantu Jr." wrote: Is it possible to set or "check" a checkbox in real time, based on the contents of a cell? I know the cell link field can tie a cell to a check box, but (if I understand it right) it's a one way link (meaning the cell reacts to the check box). Any help would be appreciated. Thanks, Ramon -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checking the length of cell contents | Excel Discussion (Misc queries) | |||
Help with function to add percentage to cell based on checkbox. | Excel Worksheet Functions | |||
After checking control checkbox returning focus to the sheet | Excel Programming | |||
Checking contents | Excel Programming | |||
Checking contents | Excel Programming |