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

--


Gary

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 procedu

if varspopulated = false then
call PopulateVars
end if

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



Gary Keramidas wrote:

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

--

Gary

--

Dave Peterson

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

thanks again
--


Gary


"Dave Peterson" wrote in message
...
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 procedu

if varspopulated = false then
call PopulateVars
end if

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



Gary Keramidas wrote:

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

--

Gary

--

Dave Peterson

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

--


Gary


"Dave Peterson" wrote in message
...
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 procedu

if varspopulated = false then
call PopulateVars
end if

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



Gary Keramidas wrote:

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

--

Gary

--

Dave Peterson