Variables between modules

[Lavina]

Hello guys,

I've been having trouble getting global variables to work.

Module1 code:

Option Explicit Public Test As Variant
Sub init()
test = 2
Call testing
End Sub

Module2 code:

Option Explicit Sub Testing()
test = 3
End Sub

All i want is to throw over my test variable value and update it. But once i reach module2, no value exists for test and once done the value of test = 2

Global instead of public yields the same result

My desired result is, test = 3. What am i doing wrong

 

[svendiamond]

Is the line "Public test as Variant" at the very top of your code in Module 1? Before any other subs? It can be after "Option Explicit" but there does need to be a space... not sure if it's just the formatting the way you pasted it into the forum but double-check that. Also did you try writing "Public Sub" instead of just "Sub" ?

 

[Fluff]

That code should work quite happily, what makes you think it isn't?