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 vote182 views1 answer
Windows Presentation Foundation dark title bar
VBA
1 vote174 views1 answer
Highlight selected cell in excel vba
VBA
0 vote167 views1 answer
Excel vba center userform
VBA
5 votes199 views1 answer
Vba low byte from INTEGER
VBA
0 vote165 views1 answer
Vba text to general
VBA
0 vote166 views1 answer
Excel vba milliseconds
VBA
5 votes208 views1 answer
Excel vba get user selected range
VBA
1 vote180 views1 answer
Excel vba to lower case
VBA
1 vote183 views1 answer
Vbscript convert ascii code to character
VBA
0 vote178 views1 answer
How to carry text to the next line in a label in vb.net
VBA