Excel 2010 Multi select drop down menus

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.
I'm hoping this is simple and not a VBA effort.
Any help would be appreciated​
 

Charles

Member
Joined
Feb 17, 2013
Messages
34
Reaction score
0
Points
6
Location
Biloxi
Excel Version(s)
Mac Excel 2011
Hi,

In the cell you want the info to appear you can use "=E1"" as an example.
E1 will be cell that you have the dropdown.
This will not work for multi select.
Are you really using a "DropDown" or "Combobox"?

Remark
After thinking about this I think you may need code. And too if the data selected goes to the same cell
it will need to be joined.
 
Last edited:

Charles

Member
Joined
Feb 17, 2013
Messages
34
Reaction score
0
Points
6
Location
Biloxi
Excel Version(s)
Mac Excel 2011
Hum,

Then I think you need code.
 

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
I will let Charles continue this. And I will lock your duplicate thread.
 
Top