When you have alot of links in a spreadsheet executing code based on
events can be problematic.

You would be better of running a routine based on time.

'This should be placed in the ThisWorkbook Module
Private Sub Workbook_Open()

Call Scan

End Sub

'Regular code module
Public Sub Scan()

'Every second evaluate Links to see if they have changed
RunWhen = Now + TimeSerial(0, 0, 1)
Application.OnTime earliesttime:=RunWhen, procedu="Scan", _
schedule:=True

End Sub



Jonas wrote in message ...
Is there a way to run a VBA macro each time that a value in the active
worksheet resolves as true etc?

Maybe there is a simpler way.

A machine process uses a DDE link to update values in a worksheet. Each
time that the value (or values) change, I want to add them to a
database.

Thanks for any help.

Jonas


---
Message posted from http://www.ExcelForum.com/