How can you fill an input box (user form) with the previous value

[Guest]

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

 

[Bob Phillips]

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.

 

[Guest]

Well, that was much easier than I thought it would be.

Thank you very much, Bob.