Darin,
You probably need a listbox which allows multiple selection.

Select the Control Toolbar (View==Toolbars==Control toolBar) and select a
list box control. Place on your worksheet and right click. select Properties
then MultiSelect ...1 fmMltiSelectMulti.

Use the ListFillRange (in Properties) to define your data list. e.g B20:B50

Add a command button to activate the processing of the listbox:

Private Sub CommandButton1_Click()
n=7
With ListBox1
For i = 0 To ListBox1.ListCount - 1
If .Selected(i) Then
.... assign data to "Answers"
e.g Worksheets("answers").Cells(n,"B")=.list(i)
n=n+1
End If
Next i
End With
End Sub

Hope this gets you started.

"Darin Kramer" wrote:



Hi There,

I need to provide users with a list of 19 items, and would like to use a
normal drop down that enables multiple selectons. I need to be able to
see the results of the selections(in say the "answer" sheet. (If it
will make it easier, I can limit the max number of seletions to say 8)
The list is part of a larger spreadsheet where data is captured on a per
row basis.
(i have been able to get a drop down with the ability to select single
items to work for other parts of the spreadsheet, but have no idea how
to enable multiple selections)

Any ideas on where to begin would be most welcome!!!!!

Thanks

D

*** Sent via Developersdex http://www.developersdex.com ***