checkbox help

D

dok112

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!!
 
N

Nigel

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
 
Top