I added a Progress Bar to a file purely for cosmetic purposes, just so my users would have an on-screen indication that something was taking place. (Trust me, most of my users are barely Windows-savvy, much less Excel-savvy....so I have to make things really simple.)
I used a few For...Next loops to slow things down like this:
For a = 1 to 10000
For b = 1 to 1000
For c = 1 to 1000
Next c
Next b
Next a
This made things go slowly enough to prevent the Progress Bar from zipping past too quickly but it really seems .... inelegant.
What other methods could be used for slowing things down?
Thanks!
El
I used a few For...Next loops to slow things down like this:
For a = 1 to 10000
For b = 1 to 1000
For c = 1 to 1000
Next c
Next b
Next a
This made things go slowly enough to prevent the Progress Bar from zipping past too quickly but it really seems .... inelegant.
What other methods could be used for slowing things down?
Thanks!
El
