L
Lina
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
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