Variables lose their values after the procedure is executed. How can on write
a code to store a value obtained from an inputb box within a code that can be
used next day when I run the code again. In other words, I would like to
retain the last value obtained and somehow keep it in the code for the next
execution of the code.

Hi Paul,

Two approaches:

1. Store your values in a xlVeryHidden worksheet.

2. Use SaveSettings or GetSettings method to save and retrieve values from
the registry.

Frederick Chow
Hong Kong
"Paul" wrote in message
...
Variables lose their values after the procedure is executed. How can on
write
a code to store a value obtained from an inputb box within a code that can
be
used next day when I run the code again. In other words, I would like to
retain the last value obtained and somehow keep it in the code for the
next
execution of the code.

You could always store it somewhere in the sheet or in named ranges in the
"variables" sheet which can be hidden.

--
Don Guillett
SalesAid Software

"Paul" wrote in message
...
Variables lose their values after the procedure is executed. How can on
write
a code to store a value obtained from an inputb box within a code that can
be
used next day when I run the code again. In other words, I would like to
retain the last value obtained and somehow keep it in the code for the
next
execution of the code.