Drop Down List and Multiple Item Selection

[KarenH119]

I am trying to set up a drop down list that allows me to select multiple items and then list them in a single cell separated by a comma. I have tried using samples that were listed in the discussion board here but I am obviously doing something wrong.

I have limited excel experience and I do not understand VBG but I was able to set up drop down list that allow one selection. I just need to get them change to multiple sections.

I have two columns that will require multiple sections from a drop down list. First list will be located in Column-G second list located in Column-I. I have the data list located on a different worksheet within the same workbook.

Data List for Column G
Printer
Phone
Scanner
Laptop
Monitor
Docking Station
Chair
Desk
File
the list is labeled SFEquipment


Data List for Column-I
Cabinets
Chairs
Desk
File Cabinet
Phone
Printer
Scanner
Shelves
the list is labeled NonSFequipment


When a new employee is added to the worksheet all the cells in Column G and Column must have these drop down lists.

Thank you for you help.
Karen

 

[robtops]

I have exactly the same issue, I've read various posts on this and other forums but can't seem to get it to work.
I have extremely limited VBA knowledge but otherwise am pretty competent on excel. I found some VBA code but have no idea how to or even if I need to link the code to the columns and the list of values. Any help would be much appreciated

Thanks

Rob

 

[thunder_anger]

you can find the answer here
Select Multiple Items from Excel Data Validation List - YouTube

 

[robtops]

you can find the answer here
Select Multiple Items from Excel Data Validation List - YouTube

Thansk very much, works perfectly for me and much easier to follow than the other places I was looking