PDA

View Full Version : Last Updated Alert



baron11
08-13-2008, 02:12 PM
I have live exchange price quotes posting into an Excel spreadsheet. I want a VBA code that would alert me if the live quotes have not been updated in the last 15 minutes.

Can anyone suggest a VBA quote or direction that I can pursue to solve this ?

Bob Phillips
08-13-2008, 02:40 PM
Is it a DDE feed? The problem with that is that it doesn't register as a change, so I think you would have to have a reference to a key cell and monitor the calculate event.