really simple question

  • Thread starter Thread starter jacksonz
  • Start date Start date
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
 
Link checkbox1 in sheet1 to the cell underneath it. (assume B9)
then
in B6 on sheet4
=if(sheet1!B9="","",if(sheet1!B9,"Yes","No"))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Progressive number in different sheets 7
hide multiple worksheets based on a formula value in one cell 1
I really need help 1
How to hide password? 1
Run two macros for two different sheets 11
Create if partial match then copy and paste data from one cell to another 1
application.activesheet, should I use it? 3

Back
Top