error messages from check box code...

[lottesfog]

Hi,
I am trying to use a check box in an excel sheet. However, this line of code:

Please Login or Register  to view this content.

produces the following error: Runtime error 424 - object required.
Why does Excel not recognise the check box as an object?

If I change the code to:

Please Login or Register  to view this content.

The following error is returned: "Runtime error 438 - Object doesn't support thid property or method"

- what's going on? The correct sheet is selected, and the "Microsoft DAO 3.6 object library" is selected under references...

Lotte

[smart89]

modify code like this

Please Login or Register  to view this content.

[BigBas]

The code

Please Login or Register  to view this content.

does not exist. As mentioned, you can use

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[lottesfog]

Thanks for the suggestions.

The

Please Login or Register  to view this content.

line produces the following error:

"Run-time error 438 - Object doesn't support this property or method"

Any ideas?

[smart89]

be sure of the name of check box in your activesheet is "CheckBox2".

[BigBas]

Can you post the full code?

[lottesfog]

Hi,
The code is shown below. The name if the check box is correct - I checked by creating a new check box and a new macro - same problem. I am usinhg Excel 2003 without SPs - could this be the problem ?
Lotte

Please Login or Register  to view this content.

[Leith Ross]

Hello Lottesfog,

There are 2 types of check boxes, the Forms type, and the Control Toolbox type. The code given so far is for the Control Toolbox type. Since it isn't working, I am betting you have a Forms type control. Try this code...

Please Login or Register  to view this content.

To "UnCheck" a Forms check box, you must set the value to the constant xlOff. Setting it to False or 0 will not work.

Sincerely,
Leith Ross

[lottesfog]

Hi Leith,
Thank you - you are correct, I was using the form type check box.
The check box appears in an excel sheet where a user should be able to check it (and thereby run a macro).
As far as i can see, the form type check box can be ticked by a user but is not easy to code with - and the control type check box can't be checked by the user - is that correct?

using the code you suggested:

Please Login or Register  to view this content.

produces the following error:
"un-time error 1004 - Unable to get checkboxes proterty of the worksheet class."

My main question now is whether, for a check box in an excel sheet which should be checked by the user, the form type or the control type would be best?

Lotte