Using VBA to select multiple criteria in 2 dropdown lists on the same sheet

[HL95]

Hi

Can someone assist i am trying to write a VBA to enable me to select multiple criteria on a dropdown list, if i have two dropdown lists both with separate criteria and i want to select multiple criteria from both list.

The below VBA works if i only have 1 dropdown list, how can i change this VBA for two dropdown lists or should i use a differenct code?
Private Sub Worksheet_Change(ByVal Target As Range)

Dim Oldvalue As String
Dim Newvalue As String
On Error GoTo Exitsub
If Target.Address = "$B$7" Then
If Target.SpecialCells(xlCellTypeAllValidation) Is Nothing Then
GoTo Exitsub
Else: If Target.Value = "" Then GoTo Exitsub Else
Application.EnableEvents = False
Newvalue = Target.Value
Application.Undo
Oldvalue = Target.Value
If Oldvalue = "" Then
Target.Value = Newvalue
Else
If InStr(1, Oldvalue, Newvalue) = 0 Then
Target.Value = Oldvalue & ". " & Newvalue
Else:
Target.Value = Oldvalue
End If
End If
End If
End If
Application.EnableEvents = True
Exitsub:
Application.EnableEvents = True
End Sub

Thanks

 

[My Aswer Is This]

You said:
if i only have 1 dropdown list
Define dropdown list:

Do you mean listbox or Datavalidation list.

Please explain what your ultimate goal is.

You showed:
If Target. Address = "$B$7" Then
Do you mean if Target. Address= B7 or B5