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