POP-UP Alerts in Excel

[davey11372]

Is there a way to create Pop-Up Alerts/DialogBox - based on a cell value - (kind of conditional formatting) ... ?

 

[Joe4]

Take a look at Data Validation, which will pop-up warnings if a cell does not meet certain conditions.

If you need more help, please provide more details (maybe an example).

 

[davey11372]

Thnx Joe, I will look into Data Validation.

I am trying to create alerts when certain cell values reflect stock prices. I have a list of stocks with live data feeds. When the price of a stock (in a cell) equals a certain price/value, I want a pop-up which announces the stock symbol and the price.

 

[Joe4]

If you have streaming stock prices which are automatically updated, I don't know if Data Validation will work. Data Validation typically works for values being manually entered into a specific cell, not by formulas or links.

You may need to look at something a bit more complex, like some Event Procedure VBA code (specifically, the Worksheet_Calculate event).

These kind of questions have been asked a lot on this board (streaming stock prices). If you do some searches on this board, you should be able to find many posts on this subject.