Video tutorial: Progress bar vs macro performance

In the last video I showed You my simple example of progress bar and talked about its advantages. But we didn’t talk about its impact on macro performance and this is the topic of this video. Watch it here or go to my channel.
Enjoy the video, please leave a like and subscribe!

Video tutorial: Progress bar – watch your macro performance

Starting to code in VBA I always wanted to see that loading rectangle as a progress bar to watch the working macro. Not only for fancy issue, but mainly to know in which point of macro I am. In this video I’ll show You simple example of progress bar. Watch it here or go to my channel.
Enjoy the video, please leave a like and subscribe!

Progress bar refresh – macro performance

In my previous post https://simpleexcelvba.com/progress-bar-simple-thing-to-watch-your-excel-macro/ I already described how to create simple progress bar and how to implement it into code. It is so much better to watch the macro performance, than freezed screen. In case You have to stop macro, it is even easier to do this with bar, than without it. But I have never thought about what impact have that visualization of progress bar on macro performance.

Continue reading “Progress bar refresh – macro performance”

Progress bar – simple thing to watch your Excel macro

Starting to code in VBA always wanted to see that loading rectangle as a progress bar to watch the working macro, for instance like in every software or game installation. Not only for fancy issue, but mainly to know in which point of macro I am.

So, what do we need to have a progress bar?

First of all, we need to create a form. It should have at least 1 textbox or label and the main thing – frame and label inside that frame.

Progress bar- Simple Excel VBA
Continue reading “Progress bar – simple thing to watch your Excel macro”