How to run a macro when cell value > 5

[spasito]

I have an excel VBA question. I have a live data feed where the price is displayed in sheet1, cell B2. Is there a way to have excel automatically run a macro when the cell value is > 5? I have other macroes running from time to time, so I can't do a continous loop checking for cell value > 5.

Thanks
Chris

 

[SkipVought]

Hi,

There are various events that can be used to trigger VBA procedures. One of the events is Worksheet_Change. However, an automatic update does not result in firing the Worksheet_Change event. :-(

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com