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 vote265 views1 answer
Change whcih control a user has selected vb
VBA
0 vote278 views1 answer
Excel vba StartUpPosition
VBA
-1 vote299 views1 answer
Code for reading letters only in vb 6
VBA
3 votes278 views2 answers
Vba active workbook path
VBA
0 vote254 views1 answer
Excel vba formatconditions range
VBA
0 vote280 views2 answers
Get excel file from email attachment in vba
VBA
0 vote259 views1 answer
Check if program is running vbnet
VBA
2 votes261 views1 answer
Vba array contains
VBA
0 vote280 views1 answer
Openfiledialog specific folder
VBA
0 vote307 views1 answer
Excel vba first column in range
VBA