You could use a listbox from the Forms toolbar and a button from the forms
toolbar to extract the choices.
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