updating a form for next use

[smokiibear]

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

 

[Norman Jones]

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.

 

[Dave Peterson]

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