This blog aims to summarize and gives good practices and objects to use in the context of data manipulation under VBA (Virtual Basic for Applications) in the Microsoft Office tool Excel. VBA is an object-oriented language created in 1985 and used by millions of people in the world every day.
What are the uses of VBA?
In a world where data processing has taken a considerable scale, the Excel tool proves to be one of the most used daily by companies (Finance, Marketing, HR, Accounting, Business, Science…) and individuals. The VBA development language integrated into Excel optimizes, automates, and promotes efficiency through the macro implementation of the procedures (Sub) or functions inside modules, which designates a series of instructions. You will be able to manipulate hundreds of thousands of data quickly if the algorithmic logic implemented is optimal.
Is VBA just Excel?
No, VBA is present in Microsoft Office applications, including Office for Mac OS and Windows. However, it can be challenging to program a code compatible with Windows and Mac.
Is VBA worth learning in 2022?
Even if Microsoft has not updated VBA since 2008, this language is still in Microsoft applications. If you plan to work with Microsoft programs and you would like to automate Excel processes and exchange data between Office applications, it is worth learning VBA. This language is still easy to use, with a simple installation. To automate analytics projects and reports, corporates still use Office applications every day. You will be more productive and faster working with VBA. Excel is a program that works well and it will certainly work for a long time. Learn VBA to build a good programming knowledge base and quickly apply it to your needs. Learning Python will allow you to go much further on multiple concepts (data, analyzes, visualizations, predictions, web applications…).
Articles in this blog will be updated and improved over time, focusing on the fundamentals of VBA macro programming. The mastery and knowledge of these blog articles will make you a great developer in VBA. You will improve your algorithmic skills.
Do you want to improve your knowledge and skills in writing your VBA applications? You have no VBA experience, you are a new programmer, or are you already a good developer? How to use VBA code in Excel? Don’t worry, you will learn to handle the Excel objects with VBA as rows, columns, sheets, workbooks, range, and cells that are key elements of your spreadsheet. You will also learn how VBA can interact with Microsoft Office applications as Outlook to send automatic email, Word, PowerPoint, and manipulate the Windows project explorer.
To handle huge data, you will see useful concepts like a dictionary or how to create your To handle data, you will see concepts like a dictionary or how you can create your custom objects with class modules. You will find here several tips and tricks to learn, discover, and improve your developer skills.
VBA is object-oriented programming (OOP). You can customize your classes. However, this part of the VBA language has some limitations. Several principles of object-oriented programming are not available such as inheritance or polymorphism. To override, we will see different methods.
VBA is a simple language, easily accessible that requires just an installation of the Office pack. This programming language is powerful when used well.
The VBA Editor is already in the Microsoft Office application (use the keyboard shortcut Alt + F11 to open it or Fn + Alt + F11 for Mac OS users).
Python for Data
To go further, in the era of data handling, you will see how you can reconcile a powerful open-source language Python and VBA. This blog contains a section more dedicated to the Python language and its uses in the context of data manipulation, data analysis, data visualization.
I’m not an employee of a software company, just a daily work in the field of data who wants to share knowledge.
Thanks for your support & enjoy your visit.