vlookup help

[Aladd1n]

hello,

I cant figure out the proper syntax for the attached workbook. Th
first 8 options on worksheet two work perfectly ( ie when checked, the
appear on worksheet 3) I dont know how to apply the formula of th
first 8 options to the rest of the checkboxes.

Can someone please help me figure out how to do this? Thanks i
advance.

Aladdi

Attachment filename: start order2.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=46674

 

[Debra Dalgleish]

Right-click on the sheet tab for the Options worksheet.
Select View Code, and you'll see the code for the checkboxes.
Checkbox 10 (Garage Service Door) has no code between its
start and end lines
Copy the three lines of code from one of the other checkboxes
Paste between the Sub and End Sub lines of Checkbox10
Change the code to fit Checkbox10 --

Dim LastRow As Object
Set LastRow = Sheets("Start Order").Range("B39").End(xlUp)
If CheckBox10.Value = True Then Range("B12").Copy LastRow.Offset(1, 0)

Create similar code for the remaining checkboxes.