Chapter 5

VBA Sub and Function Procedures

In This Chapter

arrow Understanding the difference between Sub procedures and Function procedures

arrow Executing Sub procedures (many ways)

arrow Executing Function procedures (two ways)

Several times in preceding chapters, I mention Sub procedures and allude to the fact that Function procedures also play a role in VBA. In this chapter, the secrets are revealed, and I clear up any confusion about these concepts.

Subs versus Functions

The VBA code that you write in the Visual Basic Editor is known as a procedure. The two most common types of procedures are Sub and Function.

check.png A Sub procedure is a group of VBA statements that performs an action (or actions) with Excel.

check.png A Function procedure is a group of VBA statements that performs a calculation and returns a single value (or an array).

Most of the macros you write in VBA are Sub procedures. You can think of a Sub procedure as being like a command: Execute the Sub procedure and something happens. (Of course, ...

Get Excel VBA Programming For Dummies, 3rd Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.