If the next time is still in that same excel session, maybe you could just hide
the form instead of unloading it???

wrote:

I have a user form where I has some default variables that show when my
routine is started. The user can then change the variables. However,
I've been trying to create a sub-routine that could save new default
settings, so that when the routine is run the next time, the same
settings do not need to be re-entered. I have been trying to do this
without using an output file, which I don't want to have.

what i have is something like this:

on startup, a default procedure useses this code:

.tb1.value=.tb1.text

then, i have a command button that does this:

.tb1.text = tb1.value

however, the text setting does not get saved for the next running of
the procedure. Is there a way to do this without using an input/output
file?

thanks

Smokii

--

Dave Peterson