really simple question

J

jacksonz

Okay. I have check boxes on three sheets. I have a fourth sheet tha
i have a form on. I have a button on the third sheet. Once the perso
is done checking all the boxes on the third sheet, he/she will click th
button. That will fill in the cells on my form.

Now, I have no clue about VB, but I have to do this for work. How do
store the answers of the check boxes as yes and no answers. Then, wha
commands would i use to say, for example, the value of checkbox 1 fro
sheet 1 and put it in cell B6 on sheet 4?

Thank you in advance for all your insigh
 
T

Tom Ogilvy

Link checkbox1 in sheet1 to the cell underneath it. (assume B9)
then
in B6 on sheet4
=if(sheet1!B9="","",if(sheet1!B9,"Yes","No"))
 
Top