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:

How to return a result from VBA function?

As You may know, in general in programming to return a result from function there is Return statement. Even Visual Basic has it. Unfortunately there is no such thing in VBA. In this article I’m going to show You how to return a result from VBA function.

(more…)

Author: Tomasz Płociński

I'm very advanced in VBA, Excel, also easily linking VBA with other Office applications (e.g. PowerPoint) and external applications (e.g. SAP). I take part also in RPA processes (WebQuery, DataCache, IBM Access Client Solutions) where I can also use my SQL basic skillset. I'm trying now to widen my knowledge into TypeScript/JavaScript direction.

How to create factorial function in VBA?

This time something different. We will go back to the math lessons. In this article I will show You 5 ways of how to create factorial function in VBA.

(more…)

Author: Tomasz Płociński

I'm very advanced in VBA, Excel, also easily linking VBA with other Office applications (e.g. PowerPoint) and external applications (e.g. SAP). I take part also in RPA processes (WebQuery, DataCache, IBM Access Client Solutions) where I can also use my SQL basic skillset. I'm trying now to widen my knowledge into TypeScript/JavaScript direction.

How to destroy Scripting Dictionary?

I love dictionaries! This is amazing object to create magical list of anything and to find any in just a second! But after they are not in use anymore, how to set them to nothing? How to destroy Scripting Dictionary?

(more…)

Author: Tomasz Płociński

I'm very advanced in VBA, Excel, also easily linking VBA with other Office applications (e.g. PowerPoint) and external applications (e.g. SAP). I take part also in RPA processes (WebQuery, DataCache, IBM Access Client Solutions) where I can also use my SQL basic skillset. I'm trying now to widen my knowledge into TypeScript/JavaScript direction.