How can I monitor my spreadsheet continuously?

[JJ59]

Hi,

I'd like to write a macro that can monitor my spreadsheet continuously. Here's what I want:
I can pull the dynamic stock price from my quote system to excel spreadsheet. So I'd like to have excel to alert me when my stock price is going down (or up).

I try to write a macro using "loop" but it simply doesn't work as my computer will go down.

all your advice will be appreciated

Thanks in advance,

JJ

 

[Swamp Thing]

Hi,
If you want a sub to be recognized by all the VBA code in all the sheets, then you have to write the sub in a Standard Module. In the VB editor, click Insert > Module and put your code in the Module1 window.