Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox help
hello all,
I have a quick question....i'm sure this can be done, but I have yet to figure it out. I need to create a macro that takes checkbox1 and inserts a "1" into a cell, if the box is checked, otherwise it will enter a "0" into the cell. Does anyone know how to create this? Thanks in advance for the help!! --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox help
If the checkbox is added to the worksheet then use the Linked Cell property,
if the checkbox is on a userform use the Control Source property. In both cases enter the cell reference into the properties options. Cheers Nigel "dok112 " wrote in message ... hello all, I have a quick question....i'm sure this can be done, but I have yet to figure it out. I need to create a macro that takes checkbox1 and inserts a "1" into a cell, if the box is checked, otherwise it will enter a "0" into the cell. Does anyone know how to create this? Thanks in advance for the help!! --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checkbox | Excel Worksheet Functions | |||
checkbox | Excel Discussion (Misc queries) | |||
How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) | |||
checkbox | Excel Worksheet Functions | |||
Checkbox value | Excel Programming |