Month: November 2022

HOW VISUAL BASIC FOR EXCEL ACCESS TO THE SPREADSHEET? Visual Basic for Applications (VBA) is an object-oriented programming language. Every application built in VBA will use different individual objects for performing the...

WHAT IS THE VISUAL BASIC EDITOR? In the previous lesson we saw how to check the code generated when we record an Excel macro. This code was created in a new window and only can be maintained in it. This window is what we call...

As we have seen in the previous post, it is possible to create Macros in Excel without the need for coding. For doing this, we need to record it using the Macro Recorder. Internally, a recorded Macro generates a VBA procedure...

Excel VBA (Visual Basic for Applications) is the programming platform provided by Microsoft for Excel spreadsheets. As described in its name, it allows programming in Visual Basic language, adding functions for managing directly...