Access a Variable from the Worksheet
 

Is there anyway to link the value of a public variable in a module to a Name
in the worksheet?

For example:

Public mesge As String
Sub anything()
mesge = "Hello World"
End Sub

and then somehow define a Name of the worksheet so that:
=mesge
would display:
Hello World
--
Gary''s Student - gsnu200800

Access a Variable from the Worksheet
 

Activeworkbook.Names.Add Name:="msge", RefersTo:="Hello World"

--
__________________________________
HTH

Bob

"Gary''s Student" wrote in message
...
Is there anyway to link the value of a public variable in a module to a
Name
in the worksheet?

For example:

Public mesge As String
Sub anything()
mesge = "Hello World"
End Sub

and then somehow define a Name of the worksheet so that:
=mesge
would display:
Hello World
--
Gary''s Student - gsnu200800

Access a Variable from the Worksheet
 

PERFECT!
--
Gary''s Student - gsnu200800


"Bob Phillips" wrote:

Activeworkbook.Names.Add Name:="msge", RefersTo:="Hello World"

--
__________________________________
HTH

Bob

"Gary''s Student" wrote in message
...
Is there anyway to link the value of a public variable in a module to a
Name
in the worksheet?

For example:

Public mesge As String
Sub anything()
mesge = "Hello World"
End Sub

and then somehow define a Name of the worksheet so that:
=mesge
would display:
Hello World
--
Gary''s Student - gsnu200800