none
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 ?

    regards

    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 (http://www.eileenslounge.com)

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