Thread: Run Macro on Cell Change

Hi
This worksheet event maybe useful for you

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Range("YourCellAddress"), Target) Is Nothing Then
        'Run Your Macro
    End If
End Sub

How to Save a Workbook Event Macro

1. Copy the macro using CTRL+C keys.
2. Open your Workbook and Right Click on any Worksheet's Name Tab
3. Left Click on View Code in the pop up menu.
4. Paste the macro code using CTRL+V
5. Save the macro in your Workbook using CTRL+S