| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Access a VBA global variable/constant from a worksheet cell | Excel Programming | |||
| Access variable from form and module? | Excel Programming | |||
| Access to Variable | Excel Discussion (Misc queries) | |||
| Passing variable to Access | Excel Programming | |||
| I Need VBA Assistance regarding passing a variable from Access | Excel Programming | |||
Linear Mode
