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 vote144 views1 answer
Vba sort multiple columns
VBA
0 vote169 views1 answer
Winforms dark title bar
VBA
0 vote138 views1 answer
Selecttoken em vbnet e json
VBA
0 vote134 views1 answer
Vba collection key list
VBA
0 vote148 views1 answer
Columns dont autoresize on program start vb.net
VBA
-1 vote143 views1 answer
How to correct a number to 2 decimal places in vba
VBA
0 vote137 views1 answer
Convert unix to date vba
VBA
0 vote137 views1 answer
Vba code to open a file with login rights
VBA
0 vote148 views1 answer
Dynamically change drop down list visual basic
VBA
0 vote136 views1 answer
Enable macros on opening workbook vba
VBA