Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access a VBA global variable/constant from a worksheet cell
I want to declare several constants in VBA that should be accessible from the
worksheet cells. Is it at all possible? I tried several combinations of GLOBAL, PUBLIC, inside workbook/workbook_open, inside workbook/general, inside a user module/general, inside a user module/some function. Can get the value displayed in a MsgBox and the like, but whenever I try to assign it to a cell I get the #NAME error. I know I could just assign it to some hidden cell in the workbook but I thought there must be a cleaner solution... Thanks in advance! Lina |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access a VBA global variable/constant from a worksheet cell
You could make the cell value equal to the constant, but you can't access it
from the cell. What you can do is create a name for the constant with Insert/Name/Define and access that from a cell. Create a name called glad, and in the Refers to: box put your constant, Gladiator, for example. In your cell type = glad and the word Gladiator will appear. Mike F "Lina" wrote in message ... I want to declare several constants in VBA that should be accessible from the worksheet cells. Is it at all possible? I tried several combinations of GLOBAL, PUBLIC, inside workbook/workbook_open, inside workbook/general, inside a user module/general, inside a user module/some function. Can get the value displayed in a MsgBox and the like, but whenever I try to assign it to a cell I get the #NAME error. I know I could just assign it to some hidden cell in the workbook but I thought there must be a cleaner solution... Thanks in advance! Lina |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access a VBA global variable/constant from a worksheet cell
Both suggestions were great, that solved it!
Thanks a lot! Lina "Lina" wrote: I want to declare several constants in VBA that should be accessible from the worksheet cells. Is it at all possible? I tried several combinations of GLOBAL, PUBLIC, inside workbook/workbook_open, inside workbook/general, inside a user module/general, inside a user module/some function. Can get the value displayed in a MsgBox and the like, but whenever I try to assign it to a cell I get the #NAME error. I know I could just assign it to some hidden cell in the workbook but I thought there must be a cleaner solution... Thanks in advance! Lina |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stopping a constant variable cell from being copied. | New Users to Excel | |||
Global Array Constant | Excel Programming | |||
How do I access a "Global Variable" of one Workbook from another?? | Excel Programming | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
Referring to a local or global variable or constant dynamically? | Excel Programming |