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

**redsab** · 08-30-2013, 04:07 PM

Hello,

I have five check boxes, when the first one is checked I would like to check the rest of the boxes (Checkbox 2 - Checkbox 5). And also in reverse, when I uncheck the first one I would like to uncheck boxes 2 - 5. I have written the code, but it does not work. Can someone, tell me what I am doing wrong!!

Thanks
redsab

**codeslizer** · 08-30-2013, 04:34 PM

Basically for this purpose, you won't require any VBA codes, you'll have to link the controls to a common cell. Attached is your file with screenshots on how to do that.

**redsab** · 08-30-2013, 05:13 PM

codeslizer,

That works great, and was very simple. However, when I protect the spread sheet it does not allow me to check the box. Well it allows me to check one box at a time. Would there be any kind of a work-around that you can see?

Thanks,
redsab

**Solus Rankin** · 08-30-2013, 05:31 PM

try Check_Box_Help.xlsm

**redsab** · 08-30-2013, 05:45 PM

Solus,
That did work, but how did you get those check boxes highlited? What's the secreate? This is not my real worksheet, it is just a test worksheet I was working on for an example. It really astounds me the amount of brilliants that is at this forum. I have never post a question, that someone could not solve. Thanks Solus!

redsab

**Solus Rankin** · 08-30-2013, 05:51 PM

Those checkboxes are activex checkboxes instead of the standard form controls. If you right click them and select properties you can get an idea of all they can do. IMHO they are much more versatile while being easier to use.

Also they have events which standard form controls do not. (I used the click event to call the macro)

**redsab** · 09-01-2013, 05:27 PM

Solus,
I have been working with your example and modified it at bit and changed the senario. I would like to have Checkbox3 be the one you click on to automatically check box3 - box10. But I do not want it to check box1 or box2. I have programed box1 and box2 to display a message when they are checked. I am not sure how to exclude boxes 1 & 2. At the moment, if I check box3 it checks all of my boxes 1 - 10. I am new to VBA and I have not worked with Active X Controls. Would you mind to show me how to modify CheckBox3_Click() to accomplish this senario! Thanks in advance!!

redsab

**redsab** · 09-01-2013, 06:59 PM

Solus,
Nevermind, I came up with a solution.

Please Login or Register  to view this content.

Thanks for your help, I could not have done it without your help!

redsab

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

LinkBack

Thread Tools

Rate This Thread

Display

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

Re: I would like to run VBA code when a check box is checked.

Re: I would like to run VBA code when a check box is checked.

Re: I would like to run VBA code when a check box is checked.

Re: I would like to run VBA code when a check box is checked.

Re: I would like to run VBA code when a check box is checked.

Re: I would like to run VBA code when a check box is checked.

Re: I would like to run VBA code when a check box is checked.

Thread Information

Users Browsing this Thread

Similar Threads

Automatically check one or more check boxes when a parent check box is manually checked

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

[SOLVED] I need a pop up message when a check box is checked

Print when check box checked

Disableing a check box when another is checked

Bookmarks

Bookmarks

Posting Permissions