insert checkbox to modify cell value
 

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.

insert checkbox to modify cell value
 

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 . .
..)

--
Regards,
Tom Ogilvy



"Dmackcwby" wrote:

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.

insert checkbox to modify cell value
 

Tom,

Thank you vbery much. It worked great.

David

"Tom Ogilvy" wrote:

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 . .
.)

--
Regards,
Tom Ogilvy



"Dmackcwby" wrote:

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.