|
-
Jun 19th, 2000, 11:37 PM
#1
Thread Starter
New Member
I have an application that call several macros in excel and word and I don't know how to create a progress bar that display the progress of my aplication when is running these macros. Can somebody help me with this.
Thanks.
-
Jun 20th, 2000, 01:37 AM
#2
Hyperactive Member
Put a progress bar on your form, set the max value in the properties window and update it before or after each call you make. example like so:
RunMacro_Click()
ProgressBar1.value = 5
'Run your Macro'
'Update Progress Bar after completion
ProgressBar1.value = 15
'Run next macro'
ProgressBar1.value = 25
etc.
etc.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|