Constants can't be changed in code, that is why they are called constants.
How about storing the information in an .ini file?

RBS

"Steve E" wrote in message
...
I am wanting to get some basic user info entered via a userform or input
box
that I can store in a mdule as a constant to be called in various
routines.

In particular, I am looking to get the user smtp server address once from
my
user and save it as a constant so that I don't have to prompt them for it
over and over again to use the CDO email function that I 'borrowed' from
Ron
DeBruin's site.

My other two choices are to hard code the const for each user or find out
some way to get the CDO code to find the smtp server on its own...

Any ideas?

(please keep in mind that I'm only half way thru "ExcelVBA for Dummies"
and
running XL2003)

TIA,

Steve