A
avveerkar
Can some one give me a hint as to how I can write a sub to display
elapsed time meter on the sheet, say in one of the cells? This should
tick evey second while my other macros are running. I want to time
running of my macros but I want to see this timer ticking every second
as my macros execute and not just show total time elapsed for running my
macros. I think I need to know how to trigger an event automatically
every second and then sink it in my "timer" sub to display the time. I
need hint to generate event every second.
Thanks in anticipation.
elapsed time meter on the sheet, say in one of the cells? This should
tick evey second while my other macros are running. I want to time
running of my macros but I want to see this timer ticking every second
as my macros execute and not just show total time elapsed for running my
macros. I think I need to know how to trigger an event automatically
every second and then sink it in my "timer" sub to display the time. I
need hint to generate event every second.
Thanks in anticipation.