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 vote380 views1 answer
Vba excel do not recalculate before save
VBA
0 vote341 views1 answer
Dynamically change drop down list visual basic
VBA
5 votes373 views1 answer
Excel vba low byte from INTEGER
VBA
0 vote375 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
2 votes388 views2 answers
Excel vba if sunday or staurday
VBA
2 votes345 views1 answer
Excel vba extract file name
VBA
0 vote351 views1 answer
Excel vba open browser
VBA
0 vote349 views1 answer
Excel vba show developer tab
VBA
0 vote378 views1 answer
Excel vba protect sheet
VBA
0 vote332 views1 answer
Putting marquee in vb.net
VBA