Form Control CheckBox check/uncheck via code

Hi,

I am trying to figure out how to check/uncheck a form control checkbox through code based upon the true/false result of another checkbox, but cant seem to get it. I am not sure if it is possible. The following codes are the two (of many) tries. Can anyone tell me what I am doing wrong?

Please Login or Register  to view this content.

and..........

Please Login or Register  to view this content.

I have tried many others, for example ws.Range ("BI9").Value = True........or "True" to no avail.

I would appreciate any help.

Thank you,
JasonRay

DavesExcel,
They are two attempts at the same thing. I just made a rule for posting - never post two examples of code when asking for advice for a single issue. Sorry all.
The following is what I was attempting;

Please Login or Register  to view this content.

If that makes anymore sense I would be very grateful for any advice you or anyone else could give me.

Thank you ,
JasonRay

xladept,
I tried it a million times with 10 million variations and couldn't get it to work, but that was last night.
Evidently I was punchy as upon retry today it worked almost how I wanted it to.

Thank you much for your help.

Solved.

JasonRay

Almost because I was looking to get checkbox1 to affect checkbox2 with no user intervention in checkbox2 (which your code accomplishes) but not vice versa. So with your code if the user checks checkbox2 it also affects checkbox1, which is what I did not want to happen. But that is ok, because you have led me down the trail whereby I think I can figure it out myself, which is part of the learning experience. I still thank you as you removed a brain road block and I can now tarry forth in the dark forest myself. (until I encounter another road block and ask for rescue from this life-saving forum, that is). lol.

Thanks again.
JasonRay