Use a variabel
Not sure of the best suggestion here as its not something
I normally do. But one obvious way is to wrtite a public
function in your module - this code assumes your global is
called fred and is a string. I also entered a set method
for testing.
Public Fred As String
Public Function GetFred()
GetFred = Fred
End Function
Public Function SetFred(AString As String)
SetFred = AString
Fred = AString
End Function
|