View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Thomas Thomas is offline
external usenet poster
 
Posts: 107
Default Pop-Up for Range

The worksheet I'm working on is stock data updated by DDE real time.
Basically, I want an alert to pop up when Vol Ave Vol*0.5, showing Name.
This function is needed for about 700 stock names.

Name = B2:B701
Vol = O2:O701
Ave Vol = P2:P701

After I click on 'OK', The pop-up function is deactivated for that stock name.
Otherwise, there will be a loop.

I appreciate your help.