I use it to display a PROGRESS BAR when I'm updating a project that may take
a little time...to help the user see that SOMETHING is going on while they
wait.
If you look here:
www.mousetrax.com/Consulting_Solutions.html, and scroll down,
you'll see that as the employee review is doing it's thing to compile, I
display a progress bar. That bar is a tiny user form with a textbox inside
that is colored blue.
As various steps within the main code runs, the bar code is hit and makes
the colored textbox a little longer...and thereby repaints the display so
the new length of the blue textbox displays an updated view of the newly
lengthened textbox.
As things move along quickly in the code, the textbox continually lengthens
and displayed the new, repainted version, on the screen...thereby giving the
illusion that the progress bar is moving along as the code behind in the doc
does it's job.