I have a simple spreadsheet with three columns- in column A, I have a listing of stock symbols. In column B, I have a listing of the desired sale price of each stock (or ‘price target’). And in column C, I have the actual ‘current price’ of each stock, which contains a formula linked to an external stock pricing source. This column is real-time and is constantly updating.
The user will have multiple programs open with Excel running in the background, and what I need is the following:
When the ‘current price’ equals or is greater than the ‘price target’, then I need a message alert window to pop-up in Excel so that the user’s Excel in the taskbar flashes and the user then knows to go into Excel to view the alert. I would like for the message box to state “IBM has met its price target of $90”.
Any ideas on how to work this out would be greatly appreciated. Thanks!
(Using Excel 2003)
The user will have multiple programs open with Excel running in the background, and what I need is the following:
When the ‘current price’ equals or is greater than the ‘price target’, then I need a message alert window to pop-up in Excel so that the user’s Excel in the taskbar flashes and the user then knows to go into Excel to view the alert. I would like for the message box to state “IBM has met its price target of $90”.
Any ideas on how to work this out would be greatly appreciated. Thanks!
(Using Excel 2003)