Check Box's

JoeA

New Member
Joined
Jun 21, 2005
Messages
16
I have created a work sheet that uses several check box's for the user to make choices. After I got it working the way that I wanted I copied and pasted so that there would be 4 areas on the worksheet to calculate 4 different jobs.

All the calculations and information for each of the 4 different areas work as they should, independently, except that the Check box's seem to be linked. When I check a box in the first section, say box "A", it also checks in the other sections. Is there a way to make these check box's work independently with out creating new ones for each section?

Thank you,
Joe
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,454
Is there a way to make these check box's work independently with out creating new ones for each section?
Yes. If you go to a copied checkbox and identify the Linked cell for it, I'm assuming it'll be the same cell linked to the original checkbox. You can change the linked cell for one of those checkboxes without altering the other.

Does that help?
 

AlphaFrog

MrExcel MVP
Joined
Sep 2, 2009
Messages
16,400
If you linked the 1st checkbox to a cell, then all its copies will also be linked to the same cell. Change the linked cell in the checkbox copies to some unique cell for each checkbox.
 

JoeA

New Member
Joined
Jun 21, 2005
Messages
16
Yes. If you go to a copied checkbox and identify the Linked cell for it, I'm assuming it'll be the same cell linked to the original checkbox. You can change the linked cell for one of those checkboxes without altering the other.

Does that help?

The linked cells for each of the copies is different.
The problem I am having is the actual check box not the linked cell.
When I place a check in 1 box "A" it also checks the other three box "A"'s.
I need to be able to check the box's independently.
 

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,454
Hmmm...
I'm using Xl 03 here and I can't (so far) figure out how to make it do what you're saying.
 

AlphaFrog

MrExcel MVP
Joined
Sep 2, 2009
Messages
16,400
For a given checkbox, do you have VBA code that resets or clears the values in the linked cells of the other checkboxes? If you change the value in a linked cell, that will also change the status of it's checkbox.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,570
Messages
5,625,579
Members
416,119
Latest member
JCLLE

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top