Last Updated on February 7, 2022
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 programmation language, created in 1985, 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 in 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 Microsoft Office applications every day.
You are more productive and faster working with VBA. Excel tool works well and 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 allows you to go further on multiple concepts (data, analyses, 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? How to use VBA code in Excel? How can you improve your VBA skills?
You will learn in this blog to handle the Excel objects with VBA as rows, columns, sheets, workbooks, ranges, and cells that are key elements of your spreadsheet. You will also learn how VBA can interact with Microsoft Office applications such as Outlook to send automatic email, Word, PowerPoint, and manipulate the Windows project explorer.
To handle data, you will see dictionaries and custom class modules object.
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.
VBA is a simple language, easily accessible that requires just an installation of the Microsoft Office pack. This programming language is powerful when used well.
The VBA Editor is already in the Microsoft Office application. You can use the keyboard shortcut Alt + F11 to open it or Fn + Alt + F11 for Mac OS users.
Python for Data
Can you use VBA in Python? Can you replace VBA with Python?
To go further, in the era of data handling, you will see how you can reconcile the powerful open-source language Python and VBA. This blog contains a section more dedicated to the Python language and its uses for data manipulation, data analysis, data visualization.
I’m not an employee of a software company, just a daily worker in the field of data who wants to share knowledge.
Thanks for your support & enjoy your visit.