[VBA] Make "wbyr" a global variable

[RockandGrohl]

Hi all, can't seem to get the last piece of the puzzle...

I have a series of subs within a module where they all reference the "workbook year", which I want to set as 2020 just once in the code. I've declared it as such:

Public wbyr as Integer
wbyr = 2020

However when I run, I get:

"Invalid outside procedure"

All the guides I can see online show you how to set up a global variable, but not how to define what that variable is.

Thanks!

 

[pgc01]

Hi

The assigment must be inside a procedure.

 

[sykes]

I think the problem's occurring because you're not actually running any code to declare the variable.
Your line:

wbyr = 2020

...isn't actually being run.

Normally, to declare a global variable, you'd declare it in the workbook_open event - or at least soon after, in order to get it into memory, ready to be used.

If you go into your "Immediate" window now, and run that line, that's set the variable, and the rest of your code should run properly.

 

[CephasOz]

The declaration of the variable is fine where it is, but the assignment of the value is not. Instead, use:

Public Const wbyr As Integer = 2020

 

[RockandGrohl]

The declaration of the variable is fine where it is, but the assignment of the value is not. Instead, use:

Public Const wbyr As Integer = 2020

Working beautifully, thank you!

 

[CephasOz]

You are welcome.