Calling Subroutines
A subroutine declaration has the form:
[Public or Private] Sub SubroutineName(Param1 As DataType1, _ Param2 As DataType2,...)
This is similar to the function declaration, with the notable absence of the As ReturnType
portion. (Note also the word Sub
in place of Function
.)
Since subroutines do not return a value, they cannot be used within an expression. To call a subroutine named SubroutineA, we can write either:
Call SubroutineA(parameters, . . .)
or simply:
SubroutineA parameters, . . .
Note that any parameters must be enclosed in parentheses when using the Call
keyword, but not otherwise.
Get Writing Word Macros, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.