I am creating a drop down list however I want to allow the user to select
multiple items from the list.

Is this possible and if so how?

Thanks,
Jodie

Try Debra Dalgleish's sample file at:
http://www.contextures.com/excelfiles.html

Under Data Validation,
look for: DV0017 - Select Multiple Items from Dropdown List
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jodie" wrote:
I am creating a drop down list however I want to allow the user to select
multiple items from the list.

Is this possible and if so how?

Thanks,
Jodie

Thank you for the reply however what exactly do I do with the code that she
tells the read to view?

I am a beginner and have no idea how to incorporate this code to the 2
columns of data that I would like to apply this to.

Thanks,
Jodie

"Max" wrote:

Try Debra Dalgleish's sample file at:
http://www.contextures.com/excelfiles.html

Under Data Validation,
look for: DV0017 - Select Multiple Items from Dropdown List
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jodie" wrote:
I am creating a drop down list however I want to allow the user to select
multiple items from the list.

Is this possible and if so how?

Thanks,
Jodie

Which example sheet in Debra's sample (she shows several example) best suits
what you're after?

Post in plain text here, more specifics about your sheet set-up, some sample
data and expected results
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jodie" wrote in message
...
Thank you for the reply however what exactly do I do with the code that
she
tells the read to view?

I am a beginner and have no idea how to incorporate this code to the 2
columns of data that I would like to apply this to.

Thanks,
Jodie

The "samecell" worksheet is what I am trying to accomplish.

I have 2 columns of data that I would like to have the user select as Debra
shows in the "samcell" worksheet.

The user should be able to select any where from 1 to all items on the drop
down list for each column.

The columns I will need to have this code written for are column G titled
"ROOT CAUSE" and column H titled "ACTION".

Here is a sample of data from my worksheet using columns A thru I:

DPT CLASS SKU SKU DESCRIPTION UNIT FILL RATE SEGMENT ROOT CAUSE ACTION GET
WELL
29 9 174319 TP Holder 90% Seasonal Residual Push No action to take - all
IDCs empty NA

Thanks,
Jodie

"Max" wrote:

Which example sheet in Debra's sample (she shows several example) best suits
what you're after?

Post in plain text here, more specifics about your sheet set-up, some sample
data and expected results
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jodie" wrote in message
...
Thank you for the reply however what exactly do I do with the code that
she
tells the read to view?

I am a beginner and have no idea how to incorporate this code to the 2
columns of data that I would like to apply this to.

Thanks,
Jodie

Try this in a copy of your book ..

Right-click on the Excel icon to the left of File on the main menu Choose
View Code

Copy n paste the workbook open code below (1) into the whitespace on the
right

'------ (1) -----
Option Explicit

Private Sub Workbook_Open()
ThisWorkbook.Sheets("SameCell") _
.Protect DrawingObjects:=True, _
contents:=True, Scenarios:=True, _
UserInterfaceOnly:=True
End Sub
'----------------

Press Alt+Q to get back to Excel

Right-click on the sheet (where you have the DV in col G. Col G = col "7")
choose View code

Copy n paste the sheet code below (2) into the whitespace on the right

'-------(2)------
Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
Dim rngDV As Range
Dim oldVal As String
Dim newVal As String
If Target.Count 1 Then GoTo exitHandler

On Error Resume Next
Set rngDV = Cells.SpecialCells(xlCellTypeAllValidation)
On Error GoTo exitHandler

If rngDV Is Nothing Then GoTo exitHandler

If Intersect(Target, rngDV) Is Nothing Then
'do nothing
Else
Application.EnableEvents = False
newVal = Target.Value
Application.Undo
oldVal = Target.Value
Target.Value = newVal
If Target.Column = 7 Then
If oldVal = "" Then
'do nothing
Else
If newVal = "" Then
'do nothing
Else
Target.Value = oldVal _
& ", " & newVal
End If
End If
End If
End If

exitHandler:
Application.EnableEvents = True
End Sub
'----------

Press Alt+Q to get back to Excel

Save the file, close it and re-open

Test out the DV you have in col G on this sheet. It should function as
desired.

I'm not savvy enough to amend Debra's code to make it work for col H as well
on the same sheet. Hang around awhile for insights from others versed in vba
to jump in.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---