Public vs Global
 

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.

Public vs Global
 

"quartz" wrote in message
...
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

Public vs Global
 

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

--
Tom Ogilvy

"quartz" wrote in message
...
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.