public variable question

[Dave Peterson]

Does the variable change?

If no, then you could use:
Public Const myConst As String = "hi there"

If yes, you could declare the variable as public, but then set it to its
original value in the workbook_open event or auto_open procedure.

Or you could be careful and check it before you try to use it:

Public VarsPopulated as boolean
public myVar as long

----
in some procedure:

if varspopulated = false then
call PopulateVars
end if

=========
Sub PopulateVars()
VarsPopulated = true
myVar = 1234
End Sub

 

[Gary Keramidas]

sorry about the time, that damn vista keeps changing it when i dual boot.

 

[Gary Keramidas]

is it possible to not only declare a public variable, but also set it to a value
to be used throughout he app?

 

[Gary Keramidas]

that's what i needed, i had public and const reversed.

thanks again