C carl Mar 9, 2004 #1 Is there a away to have a macro automatically run every 5 seconds ? Thanks In Advance.
C Chip Pearson Mar 9, 2004 #2 Carl, You can use the OnTime method of the Application object. See www.cpearson.com/excel/ontime.htm for details and example code. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Carl, You can use the OnTime method of the Application object. See www.cpearson.com/excel/ontime.htm for details and example code. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
