Subroutines and Functions

Tips, Tricks, and Answers

The following articles are available for the 'Subroutines and Functions' topic. Click the article's title (shown in bold) to see the associated article.

Passing Parameters to Functions
Functions are a programming structure that allows you to calculate and return a result. They are extremely powerful, and are therefore commonly used in programming. This tip explains how you can enhance your functions by passing information to them that can be used by the function to derive the results you need.

Understanding Functions
Functions are a programming structure that allows you to calculate and return a result. They are extremely powerful, and are therefore commonly used in programming. This tip explains what they are, why you should use them, and how to create them.

Understanding Subroutines
The heart of creating powerful programs in VBA is to understand how to create subroutines. These structures allow you to break your large programming tasks down into bite-sized chunks that can be used again and again.

Understanding VBA Functions
When you use functions, you define program routines that return values you can use elsewhere in your program.

Understanding VBA Subroutines
Using subroutines, you can divide your VBA programs into logical chunks you can easily manage.

Understanding WordBasic Functions
When you use functions, you define program routines that return values you can use elsewhere in your program.

Understanding WordBasic Subroutines
Using subroutines, you can divide your WordBasic programs into logical chunks you can easily manage.

Using Call to Run VBA Macros
An elegant way to run macros from within macros is to use the Call statement. In order to use it, you need to provide a reference from the calling project to the one being called.