Vba dropdown event

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: sebastianviereck.de

Similar codes

0 vote185 views1 answer
Wpf dark title bar
VBA
0 vote179 views1 answer
Vbnet check if string is only numbers
VBA
0 vote158 views1 answer
Vba file chooser
VBA
0 vote158 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
1 vote100 views1 answer
Ms access open form to new record
VBA
0 vote157 views1 answer
Vba first line of string
VBA
0 vote161 views1 answer
Add text to combobox drop down vb
VBA
0 vote156 views1 answer
Vbs
VBA
1 vote118 views1 answer
Vba listindex select multiple items vba
VBA
5 votes173 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA