Module Level (Private)

A module level variable is declared in the declarations section of a code module (standard, class or userform).
Module level variables can have two flavours either Public or Private.
A private module level variable is visible to only the module it is declared in.
If you declare a module level variable with the Dim statement this is equivalent to using the Private statement.
Is this the same for constants ??
This often causes a lot of confusion and should definitely be avoided.

Private sModuleLevel As String 
Dim sModuleLevel As String

Public Sub Procedure_Name()
End Sub


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext