Only run code on a checked box?

**shiftyspina** · 03-13-2014, 10:48 AM

Hi is there a way to only run code in vba on a checked box (ActiveX)

I have this.....

Please Login or Register  to view this content.

But it runs when i check and uncheck the box, i dont want it to anything when i uncheck it, and have tried

If checkbox value = !xon then cell = and also used a Change_Event for a cell so that it Calls a macro, and still cant get it to work only on a checked box.

Any help?

Dan

**scottlutes** · 03-13-2014, 11:02 AM

This may not be the best way, but it is one that I have used before. In the Checkbox properties, set the Link Cell and then use that as the change event. Something like this. This is not tested, but should give you the idea.

Please Login or Register  to view this content.

**shiftyspina** · 03-13-2014, 11:16 AM

Hi thanks for that, i will have a go with it and see if i can get the code to run how i need, thank you

Only run code on a checked box?

LinkBack

Thread Tools

Rate This Thread

Display

Only run code on a checked box?

Re: Only run code on a checked box?

Re: Only run code on a checked box?

Thread Information

Users Browsing this Thread

Similar Threads

Check Box that shows options in Combo Box if Checked, and Hides if Not Checked

[SOLVED] I would like to run VBA code when a check box is checked.

[SOLVED] When checkbox is checked it does not copy to new sheet. Only if not checked using false

[SOLVED] Check box (control form) checked or not - must be a simple way to test if box checked

[SOLVED] VBA code to get checked values and put one below another in another column

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions