Public vs Global

[Guest]

I have noticed that I can declare a variable "Public" or "Global".

What is the difference between the two?
Is there any advantage of using one over the other?

Thanks in advance.

 

[Rob Bovey]

I have noticed that I can declare a variable "Public" or "Global".

What is the difference between the two?
Is there any advantage of using one over the other?

There is no difference in effect between the two. The Global keyword is
a holdover from earlier versions of the BASIC. Most VB/VBA programmers use
Public.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

 

[Tom Ogilvy]

I believe Global is retained for compatibility. Should be no difference.