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