LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
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?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Checking to see if a user form is hidden Alteran Excel Programming 5 November 27th 09 04:32 PM
Trouble with saving user input in an Excel Form. University of Maine student Excel Discussion (Misc queries) 0 March 14th 06 07:31 PM
Efficient User Form vba coding for saving to worksheet Cheryl Excel Programming 1 July 23rd 04 02:07 PM
Saving a file from a command button with user input Owen[_6_] Excel Programming 2 July 6th 04 10:02 PM
Saving hidden data with a worksheet (preferably without using a hidden sheet) Dick Kusleika[_3_] Excel Programming 2 January 21st 04 04:39 PM


All times are GMT +1. The time now is 09:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"