Check Box's

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Assuming you're using Forms toolbar checkboxes, as I think you should, link
them all to the same cell.

--
Jim
|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?
 
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
 
Back
Top