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/

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/