Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Checking to see if a user form is hidden | Excel Programming | |||
Trouble with saving user input in an Excel Form. | Excel Discussion (Misc queries) | |||
Efficient User Form vba coding for saving to worksheet | Excel Programming | |||
Saving a file from a command button with user input | Excel Programming | |||
Saving hidden data with a worksheet (preferably without using a hidden sheet) | Excel Programming |