R Robin Hammond Jan 14, 2005 #2 Chip Pearson deals with Windows timers here: http://www.cpearson.com/excel/ontime.htm Or, I have an activex control for use in VBA here: http://www.enhanceddatasystems.com/ED/Pages/ExcelTimer.htm Robin Hammond www.enhanceddatasystems.com
Chip Pearson deals with Windows timers here: http://www.cpearson.com/excel/ontime.htm Or, I have an activex control for use in VBA here: http://www.enhanceddatasystems.com/ED/Pages/ExcelTimer.htm Robin Hammond www.enhanceddatasystems.com
J Jamie Collins Jan 14, 2005 #3 Chip Pearson deals with Windows timers <snip> Click to expand... Robin, AddressOf was added to VBA6, comtemporary with Excel2000, however OP is using Excel97 i.e. VBA5. Jamie. --
Chip Pearson deals with Windows timers <snip> Click to expand... Robin, AddressOf was added to VBA6, comtemporary with Excel2000, however OP is using Excel97 i.e. VBA5. Jamie. --
J Jamie Collins Jan 14, 2005 #4 tom said: how to use AddressOf in XL97? Click to expand... After a quick google: http://www.trigeminal.com/lang/1033/codes.asp?ItemID=19#19 Jamie. --
tom said: how to use AddressOf in XL97? Click to expand... After a quick google: http://www.trigeminal.com/lang/1033/codes.asp?ItemID=19#19 Jamie. --