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.

0 0

Post a comment