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.
This often causes a lot of confusion and should definitely be avoided.

Dim m_sModuleLevel As String 
Private m_sModuleLevel As String

Public Sub Procedure_Name()
End Sub

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