Automatically run macro when cell value changes

S

smilly

Hi,

I use the following macro to insert a header onto a chart located in a
worksheet called "chart" based on a cell reference in a different
worksheet called "jur":

Sub RefHeader()
With ActiveSheet
.PageSetup.LeftHeader = "&""Times New Roman,Bold""&14 " &
Sheets("jur").Range("A2").Text
End With
End Sub

I would like to have the above macro automatically run whenever the
value of a specific cell (C3) in the "jur" worksheet changes. Is this
possible? I have a feeling it must be done with a worksheet change
event function, and I have read the helpful Websites of David
McRitchie, Ron de Bruin, and Charles Pearson, but I fear that I'm too
inexperienced to understand how to make it work without a bit more
nudging along.

Thanks,
Scott
 
Top