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

--
Message posted from http://www.ExcelForum.com

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

--
Regards,
Tom Ogilvy




"jacksonz " wrote in message
...
Okay. I have check boxes on three sheets. I have a fourth sheet that
i have a form on. I have a button on the third sheet. Once the person
is done checking all the boxes on the third sheet, he/she will click the
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 I
store the answers of the check boxes as yes and no answers. Then, what
commands would i use to say, for example, the value of checkbox 1 from
sheet 1 and put it in cell B6 on sheet 4?

Thank you in advance for all your insight


---
Message posted from http://www.ExcelForum.com/