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 ***

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 ***

Thanks - made a good start - I can see the box with options in it, but I
cant select any, ie Im just selecting the list box.

I got lost with your advice to "Add a command button to activate the
processing of the listbox":"

I can add the button, and assign the Macro to it, but then nothing
happens when I click it. (I also then have the list box, and anothe
button, but I think the button should be part of the access

Also as there needs to be many of these, it wont really work if I have
each one with its own list box and command button - ie gets to complex
to create and for users to duplicate. Something like multiple data
validation would be ideal.... but dont think its possible?

Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!

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

Darin,
If you want to send me an sample w/book with description of what
you want, I will see if I can offer a solution. We could spend a lot of time
sending notes via this NG so this might be a better option.

FYI, there needn't be a command button per listbox1 - one could "activate"
them all. If lists are dependent on each other i.e. selection from list2 is
related to list1 then there are other solutions.

My e-mail is

HTH

"Darin Kramer" wrote:

Thanks - made a good start - I can see the box with options in it, but I
cant select any, ie Im just selecting the list box.

I got lost with your advice to "Add a command button to activate the
processing of the listbox":"

I can add the button, and assign the Macro to it, but then nothing
happens when I click it. (I also then have the list box, and anothe
button, but I think the button should be part of the access

Also as there needs to be many of these, it wont really work if I have
each one with its own list box and command button - ie gets to complex
to create and for users to duplicate. Something like multiple data
validation would be ideal.... but dont think its possible?

Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!

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

Thanks! Ive sent u mail! :)

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

You can do this with data validation and programming. There's a sample
file he

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'Select Multiple Items from Dropdown List'

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 ***


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html