Forum Discussion
check box for data input
is it possible to insert a check box that if checked it will automatically populate a seperate worksheet and if unchecked it will not? for example: i want to auto copy some info on worksheet 1 to either worksheet 2 or 3 depending on wether the checkbox in d1 or e1 on worksheet 1 is checked. is there a way to do this?
3 Replies
In the attached sheet you can check / uncheck the boxes in cells D1 and E1 in order to show the values from column B in sheet2 and / or sheet3.
- OH! thank you so much! what operation or formula do i use to get it to do this?
You can select developer -> insert controls -> check box (form control).
Then place the check box in any cell you want. Then right-click with the mouse and select format control.
In the format control screen choose checked ("Aktiviert") and any cell link ("Zellverknüpfung") and press OK.
The cell link then displays TRUE or FALSE if the check box is checked or unchecked.
