Hope this helps...
--
Kevin Backmann
"JillyB" wrote:
> I urgently need to create a drop down list in excel with multiple choice
> selections - is this possible please? How do I do it .
>
> Thanks
>
Thanks for your reply. I need to be able to select more than one choice at
a time from the drop down. Can this be done. e.g. Drop down list of areas,
i.e. southampton, reading, basinbgstoke, heathrow and I need to selec t
perhaps heathrow and reading at the same time from the drop down?
But you have to use code to get those selected values out of the listbox.
I used the controls from the Forms toolbar (View|Toolbars|Forms) and added a
listbox and a button to a worksheet.
I rightclicked on the listbox and chose "Format Control"
On the Control tab, I chose the Multi option
and I assigned an Input Range (I used A1:A10 of the same sheet)
Then I added this macro to a General module:
Option Explicit
Sub ExtractMyCities()
Dim DestCell As Range
Dim LBox As ListBox
Dim iCtr As Long
With ActiveSheet
Set LBox = .ListBoxes("list box 1")
Set DestCell = .Range("b1")
DestCell.Resize(LBox.ListCount, 1).ClearContents
End With
For iCtr = 1 To LBox.ListCount
If LBox.Selected(iCtr) = True Then
DestCell.Value = LBox.List(iCtr)
Set DestCell = DestCell.Offset(1, 0)
End If
Next iCtr
End Sub
Then I assigned this macro to the button.
The selected values will clear the values in B1:B10 and then fill B1:B10 in
order.
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
--
Dave Peterson
Col A
Office
Portsmouth
Southampton
Heathrow
Birmingham
How would the example you gave me be translated into this example please.
Thanks very much
Jill
Everything else would work the same.
--
Dave Peterson
You can type the values in comma-delimited or use a pre-existing range of cells
in a column with the values.
Note: if using a pre-existing range, if you give that range a name, the list
can be on another worksheet.
Gord Dibben MS Excel MVP
On Mon, 3 Mar 2008 06:37:01 -0800, JillyB <Jil...@discussions.microsoft.com>
DV0017 - Select Multiple Items from Dropdown List-- Select multiple items from a
dropdown list; an event macro stores selections in adjacent cell, or in same
cell. DataValMultiSelect.zip 18kb updated 22-Feb-07
http://www.contextures.on.ca/excelfiles.html#DataVal
Gord Dibben MS Excel MVP
On Mon, 3 Mar 2008 07:27:01 -0800, JillyB <Jil...@discussions.microsoft.com>
wrote:
>Hi Kevin,