Variable declaration case

[tiredofit]

I thought VBA was NOT case sensitive.

Try this:

In Module1, type:

Sub First()

    Dim b As Integer

End Sub

In Module2, type:

Sub Second()

    Dim B As Integer

End Sub

For some reason, the variable b is changed in BOTH modules to be either upper or lower case.

Is that a bug?

 

[joeu2004]

More like a "quirk", not a defect per se. In other words, it is by design.

As you say, VBA variable names are not case-sensitive. So VBA chooses the last spelling (mix of cases) that is entered. If you return to Module1 and re-enter "Dim b", all instances of "B" will be changed to "b".

I don't like this behavior any more than you do. But that's the way it is. Sigh.

PS.... I did not know that this behavior operated across modules. That is a shock, especially for procedure-local variable names.

 

[jmacleary]

Hi both

As joeu says, it is a quirk - however, as this wlil always apply throughout your workbook, it is not a probem, UNLESS you are relying on a mixed-case spelling in one module being regarded as different to a single-case in another - you couldnt actually set vba up that way anyway as all references get changed. There is a precedence - I believe that global case settings are retained then dim settings, then simple declarations in code. So for example, if you have a global of uPPer and then try to create a dim of upper, it will be altered to uPPer. In all cases though, the case wil be set to the last altered most global value.

 

[jmacleary]

ps joeu - 'procedure-local variables will be treated as such - so even if they become 'the same' they will still only have the scope they are defined in.

 

[Fluff]

So for example, if you have a global of uPPer and then try to create a dim of upper, it will be altered to uPPer.

I don't get that, If the Dim is done after the Global, it changes the case of the Global.
Also Just to point out, the Dim would wipeout the value of the Global variable

 

[shg]

In VBA, the last declaration of a variable sets the capitalization for all variables, procedures, objects, properties, methods, and enumerations of the same name project-wide. “Last declaration” includes declarations in the signature of procedures.