Public and Private Procedures

Just as variables and constants have a scope, so do procedures. We can declare a procedure using the Public or Private keyword, as in:

Public Function AddOne(i As Integer) As Integer

or:

Private Function AddOne(i As Integer) As Integer

The difference is simple: a Private procedure can only be called from within the module in which it is defined, whereas a Public procedure can be called from within any module in the project.

Note that if the Public or Private keyword is omitted from a procedure declaration, then the procedure is considered to be Public.

Get Access Database Design and Programming, 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.