Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checkbox macros
Hello,
I am new at creating macros, and am wondering if anyone can help me with a detail explanation as I can't seem to figure this out. I have created some checkboxes, and need to create a macro where if the checkbox is clicked then cell 'A1' (for example) would provide a value of '1'. if not clicked, then it would be '0'. Any help would be much appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checkbox macros
You can basically do it without macros.
Grab a checkbox from the forms toolbar, and set the link cell property to A1. This will return TRUE or FALSE depending upon the checked state, and you can transform this to 1, 0 with =--A1. -- __________________________________ HTH Bob "LN" wrote in message ... Hello, I am new at creating macros, and am wondering if anyone can help me with a detail explanation as I can't seem to figure this out. I have created some checkboxes, and need to create a macro where if the checkbox is clicked then cell 'A1' (for example) would provide a value of '1'. if not clicked, then it would be '0'. Any help would be much appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checkbox macros
Great! Thank you.
"Bob Phillips" wrote: You can basically do it without macros. Grab a checkbox from the forms toolbar, and set the link cell property to A1. This will return TRUE or FALSE depending upon the checked state, and you can transform this to 1, 0 with =--A1. -- __________________________________ HTH Bob "LN" wrote in message ... Hello, I am new at creating macros, and am wondering if anyone can help me with a detail explanation as I can't seem to figure this out. I have created some checkboxes, and need to create a macro where if the checkbox is clicked then cell 'A1' (for example) would provide a value of '1'. if not clicked, then it would be '0'. Any help would be much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
Macros warning always shows up, even if all macros removed | Excel Discussion (Misc queries) | |||
How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) | |||
checkbox that controls macros??? | Setting up and Configuration of Excel | |||
checkbox and macros | Excel Worksheet Functions |