vba dropdown event

The solution for “vba dropdown event” can be found here. The following code will assist you in solving the problem.

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”
        MsgBox “success”
    End If

End Sub

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts