i've written code select multiple options from dropdown...but that is allowing to select the same option again and again...
here is the code which i've written,,,
Private Sub WorkSheet_Change(ByVal target As Range)
Dim rngdv As Range
Dim oldval As String
Dim newval As String
If...