In columns L-T are all lists. Is there a way to create lists in each cell where you can select more than one item? I have attached an example worksheet. I will take any advice! Thank you in advance!
In columns L-T are all lists. Is there a way to create lists in each cell where you can select more than one item? I have attached an example worksheet. I will take any advice! Thank you in advance!
Here are the instructions: LINK
The steps are many .,.. too many to describe here.
How do I repeat that code so it works not only for Column L but Column L-T?PHP Code:
Private Sub Worksheet_Change(ByVal Target As Range)
' Developed by Contextures Inc.
' www.contextures.com
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 = 12 Then
If oldVal = "" Then
'do nothing
Else
If newVal = "" Then
'do nothing
Else
Target.Value = oldVal _
& ", " & newVal
' NOTE: you can use a line break,
' instead of a comma
' Target.Value = oldVal _
' & Chr(10) & newVal
End If
End If
End If
End If
exitHandler:
Application.EnableEvents = True
End Sub
Try:
Change to:Please Login or Register to view this content.
Please Login or Register to view this content.
That worked perfect! Thank you!
Great! Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks