laxmikant_74
05-22-2017, 08:45 AM
Hi Guys
I am new to VBA.Attached is a file for which I need the code.Now there are 4 columns.The first column consists of names of the companies.The second column is the market price of the respective companies that gets updated on real time basis.The third column and the fourth column consist of thhe calculated buy price and sell price of that company.Now if the market price is equal to the buy price of that company then I should get a pop up message saying " Buy Co. XYZ" or if the market price is equal to the sell price of that company then I should get a pop up message saying"Sell Co. XYZ".
Kindly help.Please remenber that the price in column 2 gets updated every second on real time basis
Thanks Laxmikant
I am new to VBA.Attached is a file for which I need the code.Now there are 4 columns.The first column consists of names of the companies.The second column is the market price of the respective companies that gets updated on real time basis.The third column and the fourth column consist of thhe calculated buy price and sell price of that company.Now if the market price is equal to the buy price of that company then I should get a pop up message saying " Buy Co. XYZ" or if the market price is equal to the sell price of that company then I should get a pop up message saying"Sell Co. XYZ".
Kindly help.Please remenber that the price in column 2 gets updated every second on real time basis
Thanks Laxmikant