Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
A "previous" button on a user form | Excel Discussion (Misc queries) | |||
Re-Populating Previous Answers into a User Form from the Spreadshe | Excel Programming | |||
User Input Form | Excel Programming | |||
Help with a User Input Form | Excel Programming |