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.
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.
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.When you enter the dot, a context window will pop up showing all the attributes/methods available.![]()
Private Sub CheckBox2_Click() With CheckBox2 . End Sub
David
(*) Reputation points appreciated.
Thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks