View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gregory Turk Gregory Turk is offline
external usenet poster
 
Posts: 6
Default How can you fill an input box (user form) with the previous value

Would anyone know how I might fill an input box on a user form with the value
that was entered on the previous time the user form was used. For example, if
"John Doe" is entered in the input box on a user form and then the user form
is closed, is there a way to have "John Doe" appear within the input box of
the user form when the form is opened the next time?

Any help given would be greatly appreciated.

Gregory Turk