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

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

--
__________________________________
HTH

Bob

"Gary''s Student" <(E-Mail Removed)> wrote in message
news801BE48-E48F-4C6A-89C9-(E-Mail Removed)...
> 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

PERFECT!
--
Gary''s Student - gsnu200800


"Bob Phillips" wrote:

> Activeworkbook.Names.Add Name:="msge", RefersTo:="Hello World"
>
> --
> __________________________________
> HTH
>
> Bob
>
> "Gary''s Student" <(E-Mail Removed)> wrote in message
> news801BE48-E48F-4C6A-89C9-(E-Mail Removed)...
> > 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
>
>
>