lookup options

A

Aladd1n

hello,

i am a hombuilder and i have begun creating a workbook to streamlin
some paperwork operations. the workbook has three sheets (fil
attached). the sheet named 'options' has several checkboxes fo
different options.

i would like to create a formula that searchs for all checked option
and inserts them in the 'start order' worksheet.

please take a look at the attached file and any help would be greatl
appreciated.

thanks
aladdi

Attachment filename: start order.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=45697
 
B

Bob Phillips

Hi Aladdin,

Is this what you mean

Dim chk
Dim i As Long

i = 15
With Worksheets("Start Order")
For Each chk In Worksheets("Options").CheckBoxes
If chk.Value = xlOn Then
.Cells(i, 2).Value = chk.Caption
i = i + 1
End If
Next chk
End With


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top