Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Keana Schmidt   on Oct 20 In MS Office Category.

  
Question Answered By: Finn Jones   on Oct 20

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.

Share: 

 

This Question has 6 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Userform ( .Repaint ) ? Or get search suggestion and latest updates.


Tagged: