Toggling Between Two Checkboxes

Bawb

New Member
Joined
Nov 27, 2021
Messages
9
Office Version
  1. 2010
Platform
  1. Windows
Hello everyone, I am brand new to forums, so I hope I'm doing this correctly?
I found the below instruction to get checkboxes to mimic each other on this site from a 2005 post by Andywiz.
I am wondering if there is a similar way to have the checkboxes do the opposite of each other? That is with a link?
I have 20 checkboxes set up in pairs. They select different forms to print depending on which box is checked. The forms are completely different. One tracks hours for a bid job and the other tracks time and material jobs. These are set up on a time card which tracks up to 10 jobs at one time. I would like either checked box to cancel out the other checkmark when clicked, only for it's associated job. Thus choosing only one sheet or the other to print for each job.
I'm brand new to coding and have worked long hours to make the forms and subroutines which print preview only the selected forms, therefore there is code attached to the checkboxes or visa/versa. I learned, only today, about buttons which already work this way. For my form I would prefer to use checkboxes.

Any help would be appreciated.


".You should be able to set an identical Cell-Link for both checkboxes...

1. Right-click on each checkbox, and select 'Format Control...'.

2. Navigate to the CONTROL tab (far-right I think).

3. Enter a cell address in the 'Cell-Link' box.

4. Do the same for the other checkbox as well, with the same cell address.

Now both the form controls should mimic each other. You could then simply hide the cell displaying the TRUE/FALSE values from the checkbox if you need to."
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,215
Messages
5,836,053
Members
430,403
Latest member
RoToR

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