Maybe you can save all the important information in a hidden worksheet in the
same workbook that holds that userform.

Remember to save that workbook -- if you want the values to be there if you
close and reopen that workbook.

Miree wrote:

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?

--

Dave Peterson