If cell value is changed then call macro

[Future_MVP]

I would like to call up a macro if a cell value is changed. This should be an easy one I am just having trouble getting the code together. Thanks in advance!

 

[Milo_Minderbinder]

Welcome to the board.

You need an event class macro. They go on the actual sheets, not in a module.

something like

Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox "hi"

End Sub

 

[Future_MVP]

Thank you, but I need to call a macro if a specific cell value is changed, ie. Range("i4")

 

[tusharm]

Search Excel VBA help for the worksheet change event. And, while looking up the help file, take a look at the Calculate event too.

Thank you, but I need to call a macro if a specific cell value is changed, ie. Range("i4")

 

[Milo_Minderbinder]

Thank you, but I need to call a macro if a specific cell value is changed, ie. Range("i4")

Lo and behold, that can be done too.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Range("I4").Address Then
MsgBox "Hi"
End If
End Sub