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.