VBA - Share variable between Modules, Worksheets & Forms ?

[fxken]

Is it possible to declare variables once to be shared between Modules, Worksheets & Forms within the same workbook?

Thank you
fx

 

[Jon von der Heyden]

Yes. These are called Public / Global variables.

In a standard module, e.g:

Dim g_blnDOESTHISWORK    as Boolean

And then somewhere in a routine, within your project:

g_blnDOESTHISWORK = True

But be aware there are instances where your variables values can be wiped (lookup state loss), so often not recommended.