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.