Hi there,
I'm trying to make a drop-down menu within which multiple answers can be selected. I found some code online that I copy-pasted into my file and it works great, except that it only applies to one cell. I would like to have this multiple-selection enabled dropdown menu for a whole column of cells on my sheet.
Here is the code:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim oldVal As String
Dim newVal As String
If Target.Address(0, 0) <> "I4" Then Exit Sub
On Error GoTo ReEnable
Application.EnableEvents = False
newVal = Target.Value
Application.Undo
oldVal = Target.Value
Target.Value = newVal
If oldVal <> "" And newVal <> "" Then
Target.Value = oldVal & ", " & newVal
End If
ReEnable:
Application.EnableEvents = True
End Sub
...where I4 is just one of the cells in which I would want this kind of drop-down menu to appear. I have never used VBA before, so the answer may be obvious to others, but my question is: how can I apply this code to cells other than I4?
Thanks!
Bookmarks