Add Code to properties in active x CheckBox

[chriswhite1982]

Is there a way to add vba/macro to code under properties of an active x checkbox in relation to the content of a specific cell? There is a sample workbook attached. Thanks.

[Tinbendr]

Yes. Go to VBA. Select Sheet1. Click View Code. At the top of the right window, there are two dropdowns. Click the left one and select the checkbox in question. It will insert the Click event. You can then change events on the right side, if so desired.

Enter this.

Please Login or Register  to view this content.

When you enter the dot, a context window will pop up showing all the attributes/methods available.

[chriswhite1982]

Thank you so much!