updating a form for next use
 

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

updating a form for next use
 

Hi Smokii

The values that you wish to access when the Userform is loaded, need to be
stored somewhere. Where is your choice, but possibilities could include :

worksheet cells, possibly on a hidden (or very hidden) worksheet
a text file
custom workbook properties
registry settings.

Normally choice of repository would be dictated by personal predeliction and
convenience/security considerations.

--
Regards,
Norman



wrote in message
ups.com...
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

updating a form for next use
 

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