dpcardiff
10-19-2011, 02:11 PM
Hi
I have created a template (.dotm) in Word 2011 which contains a user form.
The user form pops up when someone opens the template (ie a new document is created based on the template) which is great.
The user inputs the information and the document is automatically populated with the information. All good so far.
I have created a macro and assigned it to the QAT so when the user wants to change any of the information contained in the user form they click on the button and the user form pops up. The previously inputted information is still there which is exactly what I want as most people only want to change one or two bits of information.
When the document is saved and closed, then reopened, the information in the user form is lost. That is, when the user clicks on the macro to update the user form, the form pops up but it's blank. The means the user has to input all of the information again, which causes frustration.
Is there a way of coding the form so that the last set of information is displayed every time the user form called up, even when the form has been closed and re-opened?
I have attached a copy of the code for the user form.
I hope someone out there can help me!
Dawn
PS - I'm new to code so if you could keep the explanation as simple as possible I would be very grateful :)
I have created a template (.dotm) in Word 2011 which contains a user form.
The user form pops up when someone opens the template (ie a new document is created based on the template) which is great.
The user inputs the information and the document is automatically populated with the information. All good so far.
I have created a macro and assigned it to the QAT so when the user wants to change any of the information contained in the user form they click on the button and the user form pops up. The previously inputted information is still there which is exactly what I want as most people only want to change one or two bits of information.
When the document is saved and closed, then reopened, the information in the user form is lost. That is, when the user clicks on the macro to update the user form, the form pops up but it's blank. The means the user has to input all of the information again, which causes frustration.
Is there a way of coding the form so that the last set of information is displayed every time the user form called up, even when the form has been closed and re-opened?
I have attached a copy of the code for the user form.
I hope someone out there can help me!
Dawn
PS - I'm new to code so if you could keep the explanation as simple as possible I would be very grateful :)