How to copy with a checkbox

[dbow]

Hi all,

I am new to the forum and to Excel macros and such. I am reading and trying to learn.

I have a very simple task to accomplish in excel but cant seem to make it happen correctly and need some help.

I have a spreadsheet with 2 columns one containing questions that would be used for a technical test and one where I have added checkboxes. I would like to be able to go down the list of questions and select certain questions by checking the boxes and have the questions populate onto another sheet in the book.

The questions need to populate in the next available cell going down in the new sheet, skipping a cell so an answer can be written in when its printed and presented.

If a check box is unselected on the main sheet I want it to delete everything so that the test sheet remains tidy.

I have gotten really close to making this happen but have started over about 5 or 6 times.

I must say that while reading through the forum that the most difficult thing is all the different ways people perform functions within excel. Just when I find a piece that works I find another that wont fit. I am not really asking for anyone to write the full deal for me but if someone could help out with the basic outline I can figure out the rest. I think

Thanks

Dbow

 

[mikerickson]

I would set things up so that checkbox1 refered to the question in A1, checkbox2-A2, etc.

Then I would loop

Sheets(2).ClearContents
printRow=1
for i =1 until done
   if checkboxI then
     Cells(printRow,1)=Worksheets("sheet1").cells(i,1): rem question #i
     Cells(printRow+1,1)=vbNullString
     printRow=printRow + 2
   end if
next i

does that help?