Thanks very much for the responses. I think the input box would work well.

Alan


--
achidsey


"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