resetting controlsource cells

[Guest]

Greetings, all.

I have a workbook in which I provide the user a selection of CheckBox
options in user forms, The controls have ControlSource cells. I need to
change my workbook so the user can reset several ControlSource cells to a
default value. Here is a sample line of code:

Sheets("a17").Range("opaque") = False

When I attempt this I get an error message # 57121
"Application defined or object defined error"

I am at a loss for what is going wrong. Is it the code or a control
property?

Can someone please set me straight?

Thanks.

Steve H

 

[Sherry Marshall]

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.