'In VBA, GLOBAL variables must be declared ABOVE all procedures: Public MyGlobalString As String '<-- global to ALL modules Private MyGlobalLong As Long '<-- global to THIS module Sub Add(a, b, c) c = a + b End Sub