macro naming syntax

[hanasamo]

VBA programming is a whole new world to me, I've noted that there are three kinds of macro naming syntax which are "sub macro_name()", "private sub macro_name()" and "public sub macro_name()". Is there any difference between those 3?

 

[pritcham]

Hi

Firstly, the examples you give are not naming conventions for macros, they look like macros that have been converted to VBA.

Secondly, with regards to the naming conventions. The word (or lack of) in front of "sub macro_name" defines the scope of the function/sub-routine/variable etc (basically the scope defines what can reference/call the sub/function/variable).

For example:

Public Sub MySub() - this sub could be called from anywhere in your database project.

Private Sub MySub() - this sub can only be called from within the same module

Sub MySub() - defaults to Public access - see above.

Take a look in the help file under "Scope" if this isn't clear enough.

Hope that helps
Martin

 

[hanasamo]

Thank you, it's fairly clear