Question : vba dropdown event
Answered by : fantastic-falcon-rm703dih70zo
Private Sub Worksheet_Change(ByVal Target As Range)
Dim checkTarget As Range
Set checkTarget = Application.Intersect(Target, Range("my_named_range"))
If checkTarget Is Nothing Then
Debug.Print "not active range, exit"
Else
MsgBox "success"
End If
End Sub
Source : http://sebastianviereck.de/vba-dropdown-change-event-aktion-ausfuehren/ | Last Update : Tue, 01 Sep 20