insert checkbox to modify cell value

[Guest]

I'm trying to insert an ActiveX checkbox that when chosen (value true) it
will change a cell value. I know I need to add VBA coding for this but I
don't know where to begin. Any help would be appriciated.

 

[Guest]

you want to add code with code?

http://www.cpearson.com/excel/vbe.htm

You can get the code to add a checkbox from teh control toolbox toolbar by
turning on the macro recorder and adding one manually. Then turn off the
recorder and look at the recorded code ( tools=>Macro=>Record new Macro . .
..)

 

[Guest]

Tom,

Thank you vbery much. It worked great.

David