trigger a macro when changing a cell

**marcospaterson** · 03-09-2008, 07:15 PM

Hi all,

well i'm trying to create a code to run whenever i input a value in a specific cell.

i think i should write this code inside the sheet module as a private sub, just like

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

just make myself clear, i'd like to run a code whenever i input a value in cell A1.

i appreciate any suggestions.

thx
MSP

**VBA Noob** · 03-09-2008, 07:20 PM

Try

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(0, 0) = "A1" Then
    If Not IsEmpty(Target) Then
        MsgBox Target.Value
    End If
End If
End Sub

VBA Noob