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


---
Message posted from http://www.ExcelForum.com/

Store those values in a hidden sheet whenever they change.... Write
them to a registry entry, write them to a .ini file.

Keith
www.kjtfs.com


---
Message posted from http://www.ExcelForum.com/

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


---
Message posted from http://www.ExcelForum.com/

MWE wrote:
*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 *

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


---
Message posted from http://www.ExcelForum.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

--
Message posted from http://www.ExcelForum.com