Answers for "vba dropdown list event handler"

VBA
0

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
Posted by: Guest on August-25-2020

Code answers related to "VBA"

Browse Popular Code Answers by Language