Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check Box's
I have 4 forms on one tab. I have check boxs on each form. If a box is
checked on the first sheet I need the same box on the three other sheet to change to checked as well. Since they will always be the same this will save on errors in filling it out. Any Ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check Box's
Assuming you're using Forms toolbar checkboxes, as I think you should, link
them all to the same cell. -- Jim "Alex" wrote in message ... |I have 4 forms on one tab. I have check boxs on each form. If a box is | checked on the first sheet I need the same box on the three other sheet to | change to checked as well. | | Since they will always be the same this will save on errors in filling it | out. | | Any Ideas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check Box's
hi
this is untested but the theory is sound. if there are problems then it's sentax. sub cbTrueFalse() if me.checkbox1.value = true then form2.checkbox1.value = true form3.checkbox1.value = true form4.checkbox1.value = true else if me.checkbox1.value = false then form2.checkbox1.value = false form3.checkbox1.value = false form4.checkbox1.value = false end if end if The trick is to have a reference in one check box that references all the other checkboxes. you can vary this code to have one check box = true and the others = false so that only one check box can be true. to do that you would need code in all of the check boxes references the other check boxes. you can put this code in all of the check boxes(changing the form numbers accordingly) so that if one check box is true then so are all the others. post back if there are problems Regards FSt1 "Alex" wrote: I have 4 forms on one tab. I have check boxs on each form. If a box is checked on the first sheet I need the same box on the three other sheet to change to checked as well. Since they will always be the same this will save on errors in filling it out. Any Ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I increase the size of check in check boxes | Excel Discussion (Misc queries) | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
Can I create various check box's for them to show me a display lis | Excel Discussion (Misc queries) | |||
How do I check/uncheck ten or odd Checkboxes by click on one check | Excel Discussion (Misc queries) | |||
Check/Tick box's and Mandatory cells | Excel Discussion (Misc queries) |