As long as next time is still within the same Excel session, create a public
variable and store it there.

--
__________________________________
HTH

Bob

"Steve" wrote in message
...
If I have code that prompts the user for some sort of input, is it
possible
to have store the value of the variable so the next time the macro runs,
it's
available?