Activate macro based on cell value

[LB79]

I want to have a macro that constantly plays in the background lookin
for a change in a cell value. When the cell value changes a secon
macro activates. So far i have this but its not really working

can anyone help?

Sub Autpen()

Do

If Range("C1") > ("0") Then
Application.Run "'Workbook.xls'!Macro"
Else
Exit Sub
End If

Loop

End Su

 

[Ron de Bruin]

Hi LB79

You can use the change event for this

Read Chip Pearson's site about Events
http://www.cpearson.com/excel/events.htm