Can you set a variable for an entire module?

[bbalch]

I have a module that contains several subs. Each of the subs contain the variable below where the "period" is updated by 1 each month. So next month the 1019 would become 1119, then 1219.... Since each sub contains this variable you must update the "period" in every sub.

Is there a way to set the "period" variable once so that it applies to the entire module? I'm trying to only have one place to update instead of updating in all subs.

Dim period As String
period = "1019" ' update to current fiscal period

Thanks.

 

[Joe4]

Declare a public global variable.
See here: https://www.excel-easy.com/vba/examples/variable-scope.html