Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing a constant
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Constant loan payments vs. constant payments of principal | Excel Worksheet Functions | |||
Constant | Excel Discussion (Misc queries) | |||
Constant? in VBA | Excel Discussion (Misc queries) | |||
Constant | Excel Programming | |||
Selecting a constant changing Range | Excel Programming |