Code VBA

Overview of Code VBA (Create Visual Basic applications)

VBA (Visual Basic for Applications) is a programming language used to automate tasks in Microsoft Office applications, including Excel, Word, and Access. VBA code can be used to customize the functionality of these applications, and automate repetitive tasks.

Thanks to the VBA Fragment Editor, each piece of code can be previewed in a window that supports syntax highlights to help you spot blocks of code easier. You can also make code modifications to personalize it and extend functionality, find and replace strings of characters, as well as save changes to a new file or overwrite the current one.

Features of Code VBA

• Context sensitive IntelliSense lets you select code from the menu. Find and insert VBA for Excel, Access and Word following the application object model. Tooltips explain what classes and procedures do and give direct access (F1) to the relevant documentation on Office MSDN online. Additionally, VBA code generators assist in writing larger blocks of code.
• Procedure Call Builders display the meaning of each procedure's argument. For each argument you can select from suitable enums, objects or variables.
• The Code Explorer lets you navigate to procedures fast and adds many useful features such as insert procedure call with arguments, test procedure from immediate window, comment code and tidy the code indentation.
• The Class Builder and UserForm builder help you create custom classes and userforms custom dialogs with validation fast and easy.
• Extend the Code VBA library with your own code fragments and resources found online.

Code VBA can be integrated with Microsoft Access, Excel, PowerPoint, Word, Publisher, Outlook, Project, Visio and SharePointDesigner, together with AutoCAD. Microsoft Office 2016 and older versions are supported (until 2000), both 32- and 64-bit versions.