Thread: Use a variabel
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ben McBen[_2_] Ben McBen[_2_] is offline
external usenet poster
 
Posts: 14
Default 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