The code that you've supplied shows a named range, however, you have not
specified the values for that range. Also, your sheet name appears to
refer to a cell address instead of the actual sheet name. Try something
like below:

Sheet1.Range("Opaque").value = "FALSE"

Furthermore, you state that the controls are in a user form, but can I
assume that the checkboxes are linked to the below range? If not,
please let me know and I can further assist.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!