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

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