Global variables in VBA

[Captain Sensible]

Does VBA use global variables? In php I use a lot of session tokens basically just variables that can be accessed from memory in any routine. Is there a way I can also store VBA variables that can be used within any sub routine?

I have a few routines that run at a change in market and it seem pointless to have to rerun routines to get those variables again, I could echo them to the sheet but I'm guessing vba must handle global variables I just don't know the syntax

[osknows]

Hi Captain,

In a MODULE set the variable as PUBLIC, it's then accessible by all sheets, modules and classes.

eg

Code: Select all

Public modVar2 As String

this is a useful link if you want more info http://www.cpearson.com/excel/scope.aspx

[Captain Sensible]

Thanks Osknows, I did a bit of searching and came up with the public thing. Hopefully all will be OK for testing tomorrow