James,

Use the Application.OnTime method to cause code to execute on a
periodic basis. See www.cpearson.com/excel/ontime.htm for more
details and example code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"james_arackal"
wrote in message
. ..
How can I sum dynamic data coming in an excel cell with
reference to
time (every second).

-----------------
James



------------------------------------------------
Message posted from the Excel Tip Forum at
http://www.ExcelTip.com/forum/

-- View and post usenet messages directly from
http://www.ExcelTip.com
-- Hundreds of free MS Excel tips, tricks and solutions
------------------------------------------------