Change colorIndex of cells with 2 second interval (Excel2000)

[aarondewberry]

All

I have 32 teams in cells C1:C32 and 32 teams in cells E1:32.
The ColorIndex of all these cells is 2 (White). So none of the teams are visible.
What I want to do is, using CommandButton1_Click(), to change the Colorindex of C1 to 1, then 2 seconds later, change the Colorindex of E1 to 1, then 2 seconds later change the Colorindex of C2 to 1, .....E2 to 1 and so forth until all 64 teams are showing. Thus simulating a cup draw.
Any ideas?

 

[PHV]

Have a look at the Timer function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886