how to make process bar??

[Joy]

hi, could someone tell me how to show process bar in vba for ms project?

thank you very much

 

[John]

hi, could someone tell me how to show process bar in vba for ms project?

thank you very much

Joy,
Do you perhaps mean "progress" instead of "process"? If you do in fact
mean "process" what exactly is your definition?

If you are looking for a way to show a user the progress of a VBA macro,
there are various ways to do it. There is a progress or status bar that
can be displayed in a userform but when I tried it a few years back, it
was too slow and had too much processing overhead. Perhaps I just didn't
implement it properly.

The approach I use is to show progress in the window caption. The
general syntax is:
Application. ActiveWIndow.Caption = ["your progess message here"]

For longer running processes, I include a calculation that displays a
percentage. For example, if the code has a loop that cycles through all
tasks, I calculate and display a percentage based on how many tasks have
been processed. That way the user not only knows the macro is running
but also has an idea on how it is progressing.

Hope this helps.
John
Project MVP

 

[Joy]

many thanks

hi, could someone tell me how to show process bar in vba for ms project?

thank you very much

Joy,
Do you perhaps mean "progress" instead of "process"? If you do in fact
mean "process" what exactly is your definition?

If you are looking for a way to show a user the progress of a VBA macro,
there are various ways to do it. There is a progress or status bar that
can be displayed in a userform but when I tried it a few years back, it
was too slow and had too much processing overhead. Perhaps I just didn't
implement it properly.

The approach I use is to show progress in the window caption. The
general syntax is:
Application. ActiveWIndow.Caption = ["your progess message here"]

For longer running processes, I include a calculation that displays a
percentage. For example, if the code has a loop that cycles through all
tasks, I calculate and display a percentage based on how many tasks have
been processed. That way the user not only knows the macro is running
but also has an idea on how it is progressing.

Hope this helps.
John
Project MVP

 

[John]

many thanks

Joy,
You're welcome.
John

hi, could someone tell me how to show process bar in vba for ms project?

thank you very much

Joy,
Do you perhaps mean "progress" instead of "process"? If you do in fact
mean "process" what exactly is your definition?

If you are looking for a way to show a user the progress of a VBA macro,
there are various ways to do it. There is a progress or status bar that
can be displayed in a userform but when I tried it a few years back, it
was too slow and had too much processing overhead. Perhaps I just didn't
implement it properly.

The approach I use is to show progress in the window caption. The
general syntax is:
Application. ActiveWIndow.Caption = ["your progess message here"]

For longer running processes, I include a calculation that displays a
percentage. For example, if the code has a loop that cycles through all
tasks, I calculate and display a percentage based on how many tasks have
been processed. That way the user not only knows the macro is running
but also has an idea on how it is progressing.

Hope this helps.
John
Project MVP