View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default How can you fill an input box (user form) with the previous value

Gregory,

To close the form, use the Hide method, don't unload it. That way, when you
Show later, it will retain all the values.

Obviously, this won't wok if the containing workbook is closed.

--
HTH

-------

Bob Phillips
"Gregory Turk" wrote in message
...
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