Changing a constant
That one you really can't do. A constant is just that... constant. No matter
what, you can always count on it to be the same from beginning to end... What
you really want is a global variable. Change const to public, remove the "=
"Day 1" and so long as it is in a standard module you have a beginning. You
will need to initialize it when the spreadsheet is first opened (you can use
the on open event for this). It can grab the value from a cell or ???
--
HTH...
Jim Thomlinson
"achidsey" wrote:
Excel Experts,
I use a constant throughout a module of code.
I specify it with the following line of code at the top of the module:
Const CurDay As String = "Day1"
Currently, I go into the module and modify it changing Day1 to Day2, etc.
Now I am creating a user interface so others can run my code. I've created
command buttons in a spreadsheet so users don't have to go to the module
level.
My question: Is there code that will alter the value of my constant CurDay?
Specifically I want to write code that says
Change the line
Const CurDay As String = "Day1"
to
Const CurDay As String = "Day2"
How would I do this?
Thanks in advance,
Alan
--
achidsey
|