Hey,

I'm a little stuck doing this as I'm a extremely new to using excel above anything except basics.

Screen Shot 2014-03-18 at 17.57.23.png

I currently have a validated drop down on the "music playback format" column which allows me to select multiple entries which are then separated by a comma. I have done this using this code...

--------

Public Prior As String

--------

Private Sub Worksheet_Change(ByVal Target As Range)
'JBeaucaire 10/2/2009)
'These two macros create a multi-choice dropbox
If Target.Count > 1 Then Exit Sub
Application.EnableEvents = False
If Not Intersect(Target, Range("G:G")) Is Nothing Then
If Target <> "" Then
If Prior <> "" Then Target = Target.Text & "," & Prior
Prior = Target
Else
Prior = ""
End If
End If
Application.EnableEvents = True
End Sub

-------

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("G:G")) Is Nothing Then _
Prior = Target.Text
End Sub

---------

Now I'd like to do the same with the Genre column but I have no idea how to replicate this. I'd also want to put some sort of user input form in to assist in data entry.

Any help and guidance would be greatly appreciated

Thanks

Phil