Change Event

[bforster1]

Is there a way to write code that would trigger if an individual cell is changed. For instance, I have a single cell that is a drop down with 3 options "% of Revenue" "Input" or "Change from Previous Year". I need code that would trigger only if this particular cell was changed.

Thanks.

[Norie]

The following code will be triggered when A1 is changed, perhaps you can adapt it for your own needs.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("A1")) Is Nothing Then
        MsgBox "A1 has been changed"
    End If
End Sub