timer function

[vino.spider]

i need to use timer in excel.
private sub timer1_timer()
{
timer1.interval=60
if label.forecolor=vbyellow then
label.forecolor=vbblue
elseif label.forecolor=vbblue then
label.forecolor=vbyellow
}
how do you use timer and progress bar in excel 2003

 

[Juan Pablo González]

If you need a real timer, I suggest this one:

http://www.thevbzone.com/s_cls_modules.htm

Look for the cTimer.cls.

For the progress bar, look at this one:

http://j-walk.com/ss/excel/files/progressbar.exe

Explanation of file above is here:

http://j-walk.com/ss/excel/files/developer.htm

under "Control the LED Display in the StatusBar"