Declare global variable in Application level

Hi,
I need to declare a global variable in Application level not Module level.
I have declare a variable in Module1 and then Module2 with same name then complile it and get success. That means there has two variable with same name in different Module. I think this was not a proper global variable declaration by which I can allow to declare only one variable in all Module, Class every where. I have used code as below -

Option Explicit
Public MyID As Integer

Thanks,
Suman

It will only register it as an ambiguous name if you try and use the MyID variable in a module which isn't either of the Standard modules in which you have declared the variable.

If you use it in a sub or function in either of the standard modules in which it has been decalred, if you do not prefix the variable with the module in which it has been declared eg:

MsgBox Module1.MyID

VBA will assume you meant to reference the MyID that was declared in the module in which the code resides (hence it doesn not think there is an ambiguity as you have only declared the variable publicly once in each module).

Suman.biwas
Could you store the values in a text file in the temp folder for future reference?

You can declare a global variable in a standard module dedicated to globals. You can then use that global variable in any module that you want.

True

My first post was misguided I was think of another post, which I can find,
where you could save names or values ect in a txt file hidden in the temp folder for reference when work book was re opened in a non savable work book

looks like richard and roy have answer the question

I don't see why you have tried to declare the variable in each module, it is already declared in Module1. Did you run the test macros before changing my code?

Explain clearly what you are attempting.

Hi royUK
I think it was an example of what didnt/cant work

Another attempt at wording what Richard and Roy have already said


A variable declared as public at a module level is available to ALL modules.

If you declare the variable in each module with the same name then it will be treated as a unique variable within each of the modules.
BUT if you try to reference the variable name from a module where you did not declare it the complier can not determine which of the many declarations you mean and so raises a compiler error.

Simple declare the variable once.