Dear Members,
Here I have attached Excel file in which the data is live streaming from
other software.
What I need is to set popup alert for specific value of securities price.
This is a live streaming work sheet, the Colum "C" shows the company name
and Colum "E" show the current price o
Hi Ketan,
For reference check purpose please use the formula from Cell D9 to D17 as :
=RANDBETWEEN(1.4,5)
and then by using Alt+F11 and then in your sheet 1 update the code as:
Dim Nifty, Titan As String
Private Sub Worksheet_Calculate()
Nifty = Range("D10").Value
Titan = Range("D17").Value
If