Using Form Checkboxes

[texasalynn]

I have been trying to find a method using VBA that would allow me to have a generic code to use. I have about 20 sheets and each sheet has from 2 to 20 checkboxes (form not activex). How can I make the code without having to do each and everyone individually?

 

[texasalynn]

Did you try the code I posted?

yes I did and it errors out. Like I said that never works for me

 

[Rick Rothstein]

Norie - I have never been able to make Application Caller work.

Rick - the checkboxes vary, sometimes column E and sometimes Column F.

How can we tell which by looking at just the checkbox itself?

 

[Norie]

How did the code I posted error?

Are you definitely using checkboxes from the Forms controls toolbox?

 

[texasalynn]

How can we tell which by looking at just the checkbox itself?

Sorry this is so painful. I'm not sure how to explain without mudding the water. I think if I could get the code for just one scenario I can work out how to modify. I do have each checkbox linked to a cell but again not sure how to grab that info in order to make this work.

 

[texasalynn]

How did the code I posted error?

Are you definitely using checkboxes from the Forms controls toolbox?

Not sure if I understand, but I am NOT using a form but rather from the control toolbox a form control checkbox

 

[Norie]

There are 2 types of checkboxes you can add to a sheet, Forms and ActiveX, if you've used Forms checkboxes the code I posted should work

 

[texasalynn]

Thanks for your help Norie, I promise I'm not lying and I'm familiar with coding (although not an expert). But I have tried many times to understand why that code doesn't work. But appreciate your attempts at helping.

 

[Norie]

How does it not work?

What errors are you getting?

How did you actually create the checkboxes?

To add a Forms checkbox to a sheet you would goto the Developer tab then Insert>Form Controls in the Controls section.

 

[texasalynn]

There are 2 types of checkboxes you can add to a sheet, Forms and ActiveX, if you've used Forms checkboxes the code I posted should work

Right - wasn't sure that perhaps you were referring to a "forms" with items on there. I wish I could post a picture, but my work has that locked down that I can't use some of the nicer options MrExcel offers.

 

[Norie]

Here's a link to an example workbook https://app.box.com/s/bi79vbf1kylhocppbaamdchexnczv7du.