VBA use public variable when private variable has the same name

Question

Is it possible to have a 'public' variable and 'dim' variable with the same name and use both in the same sub?

Alex K. · Accepted Answer · 2014-11-28 14:26:13Z

4

The more local variable wins (shadowing).

To access the variable in the global scope you would need to qualify it with its containing module name:

Public Foo As Long

Sub g()
 dim Foo As String
 ...
 msgbox Foo
 msgbox ModuleName.Foo

answered Nov 28, 2014 at 14:26

Alex K.

177k32 gold badges276 silver badges299 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

CodeCamper Over a year ago

Can't accept the answer for 5 more minutes but as soon as I can you got it, the hierarchy is Public, Private, Dim for scope am I missing anything else?

Alex K. Over a year ago

There is also Static and Friend although the latter is for class methods only

Radek Over a year ago

There is also Global that I think is even above Public.

CodeCamper Over a year ago

Is there an MSDN documentation page on Scope, it seems strange that they have documentation for all the functions but not the basics of the language itself.

Cool Blue Over a year ago

For office 2013 the language reference is in the Office 2013 shared section

Collectives™ on Stack Overflow

VBA use public variable when private variable has the same name

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related