Run Macro When Any Cells In Sheet Change

[Guest]

How do I get a particular macro (or macros) to automatically run when any
cell in a particular range of cells change? I don't have much experience in
VBA.

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/events.htm

 

[Guest]

Brian

Use a private sub on the sheet in question.

Private Sub Worksheet_Change()
code to check what cells were changed and call appropriate macro
end sub

 

[Guest]

Thanks,

I think this is a good start in the right direction!

Brian