Return Value of CheckBox object in a worksheet. Error "Object Required"

[virgilio]

Hi,

I put a checkbox onto a worksheet and I would like to take some VBA action if it is clicked or unclicked. The way I have written the code is returning an error "Object Required", so I guess that I am not referencing it correctly. Here is my simple code:

Please Login or Register  to view this content.

Also, How do I change the name of this object from the generic name that Excel assigned? This checkbox is in a worksheet, and I'm not sure how to bring up the properties editor like I would in the VBA editor

[mrice]

Try

Please Login or Register  to view this content.

[6StringJazzer]

I replicated what you described and this code works fine for me. You probably have some other issue with something you didn't describe. What module is this code in? It should be in the module for the worksheet that has the checkbox. See my file for an example using your code.

You can attach your file here if you'd like.

To change the name, in the Developer tab click Design Mode. Then you can do one of two things:

1. Click on the checkbox to select it. Go to the address box (just above the column label "A") and retype the desired name.
2. Right-click on the checkbox, and select Properties to bring up the properties list. Then you can change the name.

[6StringJazzer]

I assumed you were using an ActiveX control, because of your reference to checkbox6.value. However, if your control is actually a Forms control, then this code will not work. You need to do this instead:

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

Me will not refer to the control; it will refer to the object that owns the code module (e.g., sheet) and will cause an error if used in a standard module.