Breaking News: Grepper is joining You.com. Read the official announcement!

vba dropdown event

Fantastic Falcon answered on August 25, 2020 Popularity 3/10 Helpfulness 1/10

answer vba dropdown event

vba dropdown event

Comment

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

Popularity 3/10 Helpfulness 1/10 Language vb

Source: sebastianviereck.de

Tags: dropdown vba

Link to this answer
Share Copy Link