Compile Error on checkbox in command button

[talt0612]

Hi all- I need some help on a (hopefully) simple problem. I have a sheet that contains an activex command button and several checkboxes. when I click the command button I get a "Compile error: Method or data member not found" at this point:

HedgeSheet.CheckBox3.Visible = True

and ".CheckBox3" is highlighted in blue. Note that HedgeSheet is set as

"Thisworkbook.Sheets("HedgeSheet")

If I run the same code with a form button, everything works as expected.
Note: I'd like to use the activex button if possible because the sheet is for a client and there are more formatting options w/ the activex.
Thanks in advance,
T

 

[Mohammad Basem]

Posting one line of code doesn't help understanding/tracking the source of error. Please post the full code or sample workbook.

Meanwhile, check that all referenced controls exist.

 

[Norie]

You can't refer to a control on worksheet like that.

If this code was in the worksheet module you could just use CheckBox3 on it's own.

Outside that module there are different ways to refer to it.

Perhaps the simplest is this where Sheet1 is the codename (not the tab name) of the worksheet the checkbox is on.

Sheet1.CheckBox3

Here's an exampel that uses the tab name.

Worksheets("HedgeSheet").OLEObjects("CheckBox3")