Making UserForm Values "Permanent"

  • Thread starter Thread starter MWE
  • Start date Start date
M

MWE

This seems like a simple question. I thought I asked it a while ago
(perhaps as part of another question), but I did a few searches and did
not turn anything up ...

How do I make userform variables that have been changed during the
execution of the application retain those new values and have the
application use them the next time the application is opened?

Thanks
 
Hi

You could also store them as a defined name in the workbook or in hidden
labels on the userform.

KenM
 
Keith: thank you for your reply. I have used hidden sheets in the
past. That works but it does seem like brute force. Wirting to the
Registry or a separate file has the disadvantage of not being
"portable".

Thanks again
 
MWE said:
*Keith: thank you for your reply. I have used hidden sheets in the
past. That works but it does seem like brute force. Wirting to the
Registry or a separate file has the disadvantage of not being
"portable".

Thanks again *
Click to expand...

Agree, it is best to keep the data with you. The regestry can be nice
since no matter where you move the excel sheet it will still look
there, but if you move it on another machine then you have to start
over. My perfered way is hidden sheets, as long as you are using semi
fast machines and have good memory brute force is sometimes the best
way. If you wanted to be sexy about it you could create a web service
that will send or recieve values from your app that are stored/written
to a database on a web server, if you are using this in a corporate
environment you dont have to worry about internet connection. But
would I do this over a hidden sheet, only if I was getting paid extra
for overtime.

Keith
www.kjtfs.com
 
Keith: thanks for the followup. After thinking a bit more about this
I have decided to use hidden sheets and have generalized the way
handle this particular need as well as a half dozen other housekeepin
chores. This will turn out to be very efficient and useful. Thank
for the prod
 
Back
Top