Tips for Defining Procedures in VBA

When you are defining a Function or Sub procedure, you have options available to you that can make your code more extensible or more flexible. The following sections discuss how to extend your procedures by using optional arguments, using parameter arrays to pass a variable number of arguments, and passing arguments by value and by reference.

In This Section

Using Optional Arguments
Add functionality without updating all the code that calls those procedures by adding optional arguments to user-defined procedures.
Using Parameter Arrays
Pass an array of arguments to a procedure by using a parameter array.
Passing Arguments by Value or by Reference
Understand the difference between passing arguments by value and passing arguments by reference when you define a procedure.

Related Sections

Getting the Most Out of Visual Basic for Applications
Write code that is fast, efficient, easy to read and maintain, and, if possible, reusable by acquiring a solid working knowledge of Microsoft® Visual Basic® for Applications (VBA) — what features the language includes and what you can do with it.
Working with Strings
Understand how to get information from strings.
Working with Numbers
Learn how to use numeric values and data types in Microsoft® Visual Basic® for Applications (VBA).
Working with Dates and Times
Manipulate date values in Microsoft® Visual Basic® for Applications (VBA), and understand how VBA stores date values internally.
Working with Files
Understand the Scripting Runtime object library, and work with drives, folders, and files as objects.
Understanding Arrays
Use arrays when you must store a number of values of the same type, but you do not want to create individual variables to store them all.
Optimizing VBA Code
Understand how to streamline your Microsoft® Visual Basic® for Applications (VBA) code to streamline your memory requirements.
Show:
© 2014 Microsoft