save userform changes

  • Thread starter Thread starter Miree
  • Start date Start date
M

Miree

at the moment at the end of my sub the user form closes and all the data lost
is there a way to save all of the changes made to user form so next time it
is opened it has the previous details in it?
 
Miree,

if you "unload" the userform, your data will be lost. If you just
"unhide" it, you'll be able to read from the userform. Unless you close
the WB of course.

You could also store the settings in the registry. Have a look at
SaveSettings and GetSettings in VBA's help. Very easy and no admin
rights necessary.

Regards,
Dominik.
 
Back
Top