View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default for next loop not working

On Fri, 24 Sep 2004 17:47:36 +0100, "Tim"
wrote:

thanks Ron, it works, but i thought if i did it as a loop, it would have a
smooth transition, it just seems to go from all to nothing in one go (maybe
i need a line to update the form?)


I haven't worked with this sort of stuff, but maybe you just need to slow down
your loop with a delay. Either a nested loop or use the Timer function.


--ron