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."
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."
