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

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

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

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

Thank you very much, Bob.