What's the Difference?

[Lil Pun]

What is the difference between:

Global variable As Boolean

Dim variable As Boolean

[mrice]

It's all to do with variable visibility

Dim X as Boolean

means that X only is visible in the module in which its declared. It would be OK to have a different variable X in another module and the code would not get confused.

Public X as Boolean

means that X is visible across all modules and can be used in any.

[Myles]

What is the difference between:
Global variable As Boolean
Dim variable As Boolean

A variable can be "global" in 2 ways: (1) if it is accessible by all codes in a module or (2) if it is accessible by all codes in a project (across all modules).

Both are accomplished by declaring the variable at the TOP of the module before the first Sub - in the case of the Ist with a DIM statement and for the 2nd with a PUBLIC statement.