Hello I am developing a feature, that reads the real time ticker price and measure time frame. To do that, I have the following parts: for example cell a1 read the time that a certain finance news published and cell b2 will get the ticket price, follow this published time. The expected output: cell c1 we show the price every 10 mins. since the finance news was publices, cell d1 will calculate the price after 20 min. ans so. I have trouble to program this lop with VB. Does anyone know how I can save the data in a cell every 10 mins. So that I can calculate the interval time. Is this only possible using VBA? Dan.
http://www.pcreview.co.uk/forums/create-timer-excel-t3843267.html http://www.ehow.com/how_5052033_insert-timer-ms-excel.html