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.
|