View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] smokiibear@gmail.com is offline
external usenet poster
 
Posts: 9
Default 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