Course Content
Chapter 9 – Multiple Worksheets and Workbooks
0/2
Chapter 10 – IF, VLOOKUP, and Other Functions
0/3
About Lesson

Excel VBA Terms

Some commonly used terms in VBA (Visual Basic for Applications) programming for Excel.

Macro – A set of instructions that automate a series of tasks in Excel. Macros can be created using VBA code.

Module – A container for VBA code. A module is a file that contains the code to be executed by a macro.

Procedure – A block of VBA code that performs a specific task. Procedures can be functions or subroutines.

Function – A VBA procedure that returns a value. Functions can be used in Excel formulas and calculations.

Subroutine – A VBA procedure that does not return a value. Subroutines are typically used to perform tasks such as formatting or data manipulation.

Object – A specific element of an Excel workbook, such as a cell, worksheet, chart, or workbook. Each object has its own properties and methods.

Property – A characteristic of an object that can be set or read using VBA code. Examples include the font size of a cell or the width of a column.

Method – An action that can be performed on an object using VBA code. Examples include formatting a cell, sorting data, or printing a worksheet.

Event – An action that occurs within Excel, such as opening a workbook or clicking on a cell. VBA code can be written to respond to specific events.

Debugging – The process of identifying and fixing errors in VBA code. This can involve stepping through code line by line, using break points, or using error handling techniques.

These are just a few of the terms that you may encounter when working with VBA and Excel. As you become more familiar with the language and the program, you will likely encounter many more.