Handling and storing values on global variables while running several macros

[Pichingualas]

Hello!

I'm using a workbook that runs 15 macros which create 18 sheets of information based on 1 sheet of raw data. At the moment, the user has to input requested values that are used for the macro that is currently running, but many of these values are repeated and all of them could be entered at the beginning, upon launching the first macro, because they all refer to locations of the data fields from the first sheet of raw data. So I'm thinking that I should stop using local variables and store them for all the macros to use, and clear them only once all of them have run. The question is how do I define global variables and where should I place the code where the values for these are entered?

Thanks in advance.

[protonLeah]

An easy way, though not the best: create new module and declare said variables as PUBLIC (for instance: Public Var1 As Long, Var2 As String, etc), use the WorkbookOpen event in the ThisWorkbook Module to initialize them.

[Pichingualas]

What way would be the best then?

[Pichingualas]

Btw I don't want to use the workbook open event because this report is suposed to be executed only once a month.

[Pichingualas]

So how do I make it for the user to input the value and let it fixed untill the last macro runs?

[Pichingualas]

Also is there a way to clear them once the code stops so as not to waste memory space?

[jaslake]

Hi Pichingualas

Something like this perhaps

Please Login or Register  to view this content.

In this instance MyString is available to all procedures in all modules until the code ends.

If all procedures that require the variable are in the same module then perhaps this

Please Login or Register  to view this content.

In this instance MyString1 is available to all procedures in that module until the code ends.

[Pichingualas]

Thanks I'll try this out.