| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using A Public Function / | Excel Worksheet Functions | |||
| Dim vs. Public | Excel Programming | |||
| Public declaration | Excel Programming | |||
| public sub | Excel Programming | |||
| Public Sub Help | Excel Programming | |||
![quartz[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
