Global variables not working on excel vba

Question

I'm trying to use global variables in a excel macro I'm creating, but i can't get them to work. I wrote te following code:

Public globalVar As Integer

Public Sub TestGlobal()
    SetGlobalVar

    GetGlobalVar
End Sub

Public Sub SetGlobalVar()
    globalVar = 5
End Sub

Public Sub GetGlobalVar()
    Debug.Print "globalVar = "
    Debug.Print globalVar
End Sub

I expected this code to show globalVar = 5, but it's showing globalVar =, and when I put the mouse over the globalVar variable in SetGlobalVar it shows "5", but when I do that on GetGlobalVar, it shows "Empty".

What am I doing wrong? Shouldn't the value be the same, since the variable is global?

Running TestGlobal here prints globalVar = then 5 on the next line as expected. Right click globalVar in the declaration line and add watch then you can debug line by line and see how its value is changing. — Alex K.
– Alex K., Commented Jan 27, 2018 at 11:48

David wyatt · Accepted Answer · 2018-01-27 14:52:05Z

3

When i run the code it works, just to check you are declaring the public variable at the top of the module and not after another sub?

answered Jan 27, 2018 at 14:52

David wyatt

3181 silver badge11 bronze badges

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

2 Comments

Marlon Over a year ago

Thats exactly it. I've already changed to 'Debug.Print "globalVar = " & globalVar', and it continued to show empty. But when i moved the global variable declaration to the top of the file it worked.

David wyatt Over a year ago

Glad I could help

Gary's Student · Accepted Answer · 2018-01-27 14:47:56Z

2

Your Immediate Window may not be high enough.

Based on Coleman's suggestion:

answered Jan 27, 2018 at 14:47

Gary's Student

96.9k10 gold badges66 silver badges104 bronze badges

1 Comment

John Coleman Over a year ago

That is a very good guess as to the source of OP's confusion. Since the code is so straightforward and works as expected, I couldn't figure out why he thought that there was a problem.

Collectives™ on Stack Overflow

Global variables not working on excel vba

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related