CODEWITHSUNDEEP
excelvbavbe
sergio trajano
sergio trajano

Reputation: 311

VBA Editor: Letter capitalization vs scope of variables

I realized that VBA Editor (Excel 2019 VBE) change case of variables when you have different variables (different scope) but same name with different case. For example, we have the code below, which have 3 "variables" Var1, Var2 and Var3, and it works fine:

Const Var1 As Long = 1
Dim Var2 As Long

Public Property Get Var3() As Long
    Var3 = 3
End Property

Sub Test_A()
    Debug.Print Var1, Var2, Var3 'prints 1 0 3
End Sub

IF we add a second subroutine Test_B, and inside it we declare 3 variables with same name but different case, var1, var2 and var3, the code still works just fine, but all 6 variables (3 module level and 3 subroutine level) change case to be in the same case as the last one declared (so module-level Var1 change to var1 because I've just declared a subroutine-level var1).

Const var1 As Long = 1
Dim var2 As Long

Public Property Get var3() As Long
    var3 = 3
End Property

Sub Test_A()
    Debug.Print var1, var2, var3 '1 0 3
End Sub

Sub Test_B()
    Dim var1 As Long, var2 As Long, var3 As Long
    var1 = 10: var2 = 20: var3 = 30
    Debug.Print var1, var2, var3 'prints 10 20 30
End Sub

Should that behaviour trying to say something? Is it some real issue to be concerned with? Or is it just fine?

Upvotes: 1

Views: 67

Answers (0)

Related Questions