Run a macro when a value changes

Ricdel

New Member
Joined
Dec 20, 2005
Messages
4
Sorry if this is quite elementary.

How do I run an existing macro when the value of a specific cell changes?
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Crow_23

Board Regular
Joined
Feb 17, 2005
Messages
183
Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub
 

GaryAtWork

Board Regular
Joined
Dec 19, 2005
Messages
83
Or maybe this in the code for the worksheet

Code:
Private Sub Worksheet_Change(ByVal Target As Range)

    Application.EnableEvents = False
    If Target.Address = "SpecificCellAddress" Then MacroName
    Application.EnableEvents = True

End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,118,760
Messages
5,574,080
Members
412,566
Latest member
TexasTony
Top