 Page [ 1 ]
|
|||
| Code Essentials Printer Friendly Version | |||
|
Beginner’s section on how to work in the VBA environment, how to work with functions and expressions – generally not specific to Outlook | ||
| Topic | |||
|
How can I create a progressbar in outlook?
I'm trying to create a progressbar. I have some vba code in a module and I want to start a progress bar when I run the vba macro. I have a loop in my module and would like to send status to the progess bar while looping. I would really appreciate the help. Thanks, Rich K. richddd 28-Oct-2003 15:16 |
||
|
|
Sue Mosher
28-Oct-2003 16:21
If you have VB, it includes a Progress Bar control. If no, I usually just use an image control with a nice background color and change the width in increments as the loop completes. |
||
|
|
richddd
28-Oct-2003 18:21
I tried a userform. During the sub I set userform1.show and at the end of the sub I set userform1.hide. But the userform1.show takes the over and stops the running of the sub. How do I show the form, continue running the sub and update it from the sub. Do I need to use doevents somehow? Thanks, Rich K. |
||
|
|
Sue Mosher
28-Oct-2003 20:41
Make sure you're not showing the userform1 modal. You need to invoke DoEvents every time you update the control on the userform and also userform1.Repaint. |
||
|
|
Adam Ruben
30-Oct-2003 12:30
There's also code for a Progress Bar in the Sample Applications in the Samples folder of the Office Developer CD, if you have access to that. |
||
|
Page [ 1 ]
|
|||
| Post a new message to this topic. name email  |