Reference if Checkbox is checked on Worksheet_Change

Hey folks,

I have another one for anyone willing to help.

I have 4 checkboxes on a worksheet and I am trying to reference each to set off a warning if the checkbox is checked in the following manner:

Please Login or Register  to view this content.

The following gives me a run-time error - "Object doesn't support this property or method".

Is there another way to reference whether the checkbox is checked or not? Is my code anywhere close?

Thanks in advance.

Hi,

If it's a Forms control checkbox, you can check it like this:

Please Login or Register  to view this content.

If it's an ActiveX control checkbox, you can check it like this:

Please Login or Register  to view this content.

Hi,

You didn't clarify which type of checkbox it is, so I'll briefly answer for both of them.

ActiveX control checkboxes do have a Change event handler. If the ActiveX control is on a worksheet then the Checkbox's Change event handler would live in that worksheet's class module.

Forms control checkboxes do not have a Change event handler but you can assign a macro to them which will run when they are changed. Right click > Assign Macro.

Hi,

Forms controls are more lightweight and therefore less buggy so, if you have to have a control on a worksheet, one generally prefers to use them rather than ActiveX for simple tasks.