Quote:
Originally Posted by Debaser
If you declare a Public variable in a class module (for example a worksheet or ThisWorkbook module) then the variable may only be accessed as a member of that class. Therefore you must refer to it using syntax such as Sheet1.Variablename or ThisWorkbook.Variablename. If the variable is declared in a normal module, you may simply refer to it using its name from any other module in the workbook.
|
Ah. So, if I've understood you correctly, I have to create a new module in the workbook and declare all the variables as PUBLIC in that module and all other modules will recognize them.
I have already tried that. It seems to work. Let's see.
Best regards,
Officer_Bierschnitt