Access a Variable from the Worksheet

[Gary''s Student]

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

 

[Bob Phillips]

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

 

[Gary''s Student]

PERFECT!
--
Gary''s Student - gsnu200800

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

--
__________________________________
HTH

Bob