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.
Printable View
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.
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.