Clear all variables? Please??

[agleinmiller]

you can declare module specific variables by declaring them as Private, therefore they will not be available outside of the module..

it's my understanding that this is true when you make a private declaration at the module level only, which is actually the same as using a dim statement at the module level. if you use a public declaration at the module level, then the variable is available outside the project as well as throughout the module. as far as i know you can't use public or private declarations at the procedure level.

to clarify, i want to declare variables such that they will be shared across multiple procedures within a single module, and i want some way to clear their values at the beginning and/or end of code execution.

i've never used class modules, and i'm not familiar with how they work and how they compare to standard modules... guess i'll have to check them out.

-agl

[JustinLabenne]

If they are declared at Module level:

Reset the values of them at the end of each procedure,

Option Explicit
 
Dim mlLongVar As Long
 
Sub ProcOne()
mlLongVar = 10
MsgBox mlLongVar
mlLongVar = Empty 'Reset to nothing
End Sub
 
 
Sub ProcTwo()
MsgBox mlLongVar
End Sub