Welcome to Simple Excel VBA

If You’d like to learn useful tricks in VBA in Excel and not only, You have come to the right place.

I invite you to Posts tab to read the latest entries. If You would like to search for articles You are interested in, use the search engine on this website and You will definitely find something in your area. There are articles on both simple and really advanced topics.

If you would like to just look at ‘funny’ pictures in the memes style, please visit the Memes tab. Maybe thanks to them you will be interested in the article they are in.

To contact me, go to About me or Contact me.

Recent posts:

Customize your VBA editor (VBE)

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.

(more…)
Tomasz Płociński

Author: Tomasz Płociński

Excel VBA enthusiast who is also open for other languages. Mainly working in VBA, some SQL, hungry for more.

Split array to increase performance

I already made article about how fast arrays can be comparing to Excel tables. You know that. You know also that arrays need some RAM memory to exist. But can we increase array performance with its split and descrease RAM usage? In this article I will show You if it is possible.

(more…)
Tomasz Płociński

Author: Tomasz Płociński

Excel VBA enthusiast who is also open for other languages. Mainly working in VBA, some SQL, hungry for more.

Issue with UCase, LCase, Format, Mid etc in VBA

The most known situation in office environment – it was working on my computer, it is not on other. This time appeared compile error Can’t find project or library, but showing me UCase issue with highlighted code line. How code could loose the library for the basic VBA function?

(more…)
Tomasz Płociński

Author: Tomasz Płociński

Excel VBA enthusiast who is also open for other languages. Mainly working in VBA, some SQL, hungry for more.