View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff[_2_] Harald Staff[_2_] is offline
external usenet poster
 
Posts: 449
Default Saving Input on User Form to Hidden Worksheet

You must write code to save and reload informations like this.

Lots of ideas.
Where to save is a question of what's practical. You can write to a sheet in
the code file, and save this file if you want it to be there after a
restart, or not save if you want it during the session only. You can write
it to the registry if you want it to be application-user unique, or a
textfile/ini file on a share/a database table, if it shall work in a
multiuser environment. You choose what's practical, but you must write the
code for this yourself, by default info dies as the userform is unloaded.

HTH. Best wishes Harald

"Brian" wrote in message
...
I have a User Form that once it is filled in, it updates several other Work
Books from different Control Buttons.

I need to save the Input on the User Form in one of the Wook Books, so
that
if the Work Book is opened again the User Form automatically Fills back
in.

Would the Information on the User Form be saved on a hidden Work Sheet in
the Work Book that I want to save it in?

Any Ideas on how to achive this?