View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default text boxes retaining their last value on form close and restart

Insert a module and declare variables to store these values which will remain
untl the user close the workbook.

If this post helps click Yes
---------------
Jacob Skaria


"NDBC" wrote:

In my user form there are 5 text boxes. Rider1 through Rider5. Is there a way
to store the values of these text boxes so the last values come up as the
starting values if the user accidently closes down the form (x in top right)
and then clicks the button to restart it.

Thanks