A Abhijeet Active Member Sep 8, 2013 #1 Hi I want macro from data in 1 workbook give random number after every 2 min in 2 workbook can show & Close that 2 workbook & open that workbook after 2 min again same.Please help for this.I use RANDBETWEEN formula but I want macro
Hi I want macro from data in 1 workbook give random number after every 2 min in 2 workbook can show & Close that 2 workbook & open that workbook after 2 min again same.Please help for this.I use RANDBETWEEN formula but I want macro
dan_l Active Member Sep 8, 2013 #2 try application.ontime You can set a timer to call a given function. That function can open a workbook, spit out a number, and close the workbook.
try application.ontime You can set a timer to call a given function. That function can open a workbook, spit out a number, and close the workbook.
SirJB7 Excel Rōnin Sep 9, 2013 #3 Hi, Abhijeet! Give a look at this link: http://chandoo.org/forum/threads/he...elapsed-time-with-5minute-visual-alarms.10418 It has an implementation of the OnTime method. Regards!
Hi, Abhijeet! Give a look at this link: http://chandoo.org/forum/threads/he...elapsed-time-with-5minute-visual-alarms.10418 It has an implementation of the OnTime method. Regards!