how to run vba with a single cell value. RRS feed

  • Question

  • Hi,

    I want to run vba with changes in cell A1 with a drop down selection change but with out Worksheet_SelectionChange . Is it possible ?


    Thursday, October 22, 2015 3:20 PM

All replies

  • You can use the Worksheet_Change event:

    Private Sub Worksheet_Change(ByVal Target As Range)
        If Not Intersect(Range("A1"), Target) Is Nothing Then
            Application.EnableEvents = False
            ' Your code here
            Application.EnableEvents = True
        End If
    End Sub

    Regards, Hans Vogelaar (

    • Proposed as answer by André Santo Thursday, October 22, 2015 5:31 PM
    Thursday, October 22, 2015 3:33 PM