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 vote230 views1 answer
Vbscript check if string is empty
VBA
1 vote239 views1 answer
Excel vba array remove first
VBA
0 vote236 views1 answer
Vbnet revrese the order of character in string
VBA
0 vote340 views1 answer
Vba line feed
VBA
0 vote244 views1 answer
Loop through lines in text file vb net
VBA
0 vote262 views1 answer
Get month number from month name vbnet
VBA
1 vote231 views1 answer
Add a index column power bi
VBA
1 vote217 views2 answers
Vba remove first 2 characters from string
VBA
1 vote236 views2 answers
Excel vba password protect
VBA
1 vote232 views1 answer
How to check is the value enterd is a number or text in vba
VBA