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!
Tag: Progress bar
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 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.
