time indication bar
 

I start a timer function in excel. This function activates
upon every time tick , for example every minute, a
procedure. Now I would like to show for example every
minute a time bar in which you can see the time from zero
seconds up to for example 60 seconds (the time between the
time ticks of the timerfunction); and then upon the next
timer function time tic start the time bar again. Is there
a solution for this problem ?
thank you