Probably the most annoying thing in VBA coding is that the editor (VBE) looks like the time stopped for him a while ago. Unfortunately it is true in some case, because as far as I know Microsoft stopped to support VBA in 2008, but officially they did not say that until 2020. The case is not only the appearance, but most of all about functionality. In this article I’m going to present 5 VBE upgrades, which will customize your VBA editor to improve your user experience.
Continue reading “Customize your VBA editor (VBE)”Category: Video
Video tutorial: Get your site status – WinHTTP Request
In this video we are going to get through the example of WinHTTP Request code to check the site status.
Watch it here or go to my channel.
Enjoy the video, please leave a like and subscribe!
Video tutorial: How to declare array in Excel VBA
In this video I’m presenting to You three methods, which I’m mainly using in my codes – array as range, loop to array and array as words list.
Watch it here or go to my channel.
Enjoy the video, please leave a like and subscribe!
Video tutorial: Store color property – array vs table speed comparison
Is it possible to store for example color property in VBA array? If yes, which approach is faster – array or standard Excel table?
Watch it here or go to my channel.
Enjoy the video, please leave a like and subscribe!
Video tutorial: Can arrays store cell color property?
We all know that arrays can store values, for example 2 dimensional array can hold standard Excel table. But can arrays store cell color property?
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!