Excel 2010 Multi select drop down menus

Status
Not open for further replies.

Doverwood

New member
Joined
Apr 29, 2014
Messages
5
Reaction score
0
Points
0
I'm not sure what category this question falls into...
I have created multiselect drop down menus in a spreadsheet.
I want to know how I can extract the users choices into another cell in the spreadsheet.
Any help would be appreciated
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
You simply create a formula that references them.

e.g. If dropdown is in A1, then formula is =A1 if you are in another sheet, then ='Sheet1'!A1 where Sheet1 is name of sheet where drop down is.
 

Doverwood

New member
Joined
Apr 29, 2014
Messages
5
Reaction score
0
Points
0
Multiselect

NBVC
Thanks for your reply. What you suggested works when the user can only select one item in the drop down. When the user has the option to select more than one, is where I'm stuck.
 

Doverwood

New member
Joined
Apr 29, 2014
Messages
5
Reaction score
0
Points
0
multisellect

NBVC
That's part of the mystery. When you use a ListBox as opposed to a conventional drop down menu, I have no idea where the data is stored.

Developer->Controls->Insert->Form Controls->List Box

The list box is not tied to a cell. It sort of sits where ever you like "above" the cells.
 
Status
Not open for further replies.
Top