PDA

View Full Version : Dumb Question



Zephid15
06-06-2007, 06:57 AM
Whats the difference between:
Sub
and
Private Sub

ctengelen
06-06-2007, 12:01 PM
Sub
Indicates that the Sub procedure is accessible to all other procedures in all modules (javascript:hhobj_6.Click()). If used in a module that contains an Option Private statement, the procedure is not available outside the project (javascript:hhobj_7.Click()).

Private Sub
Indicates that the Sub procedure is accessible only to other procedures in the module where it is declared.

fumei
06-08-2007, 08:57 AM
And it most certainly is NOT a dumb question. Knowing and understanding Scope is a very important piece of information.