ajhez
05-25-2015, 07:07 AM
Hi all,
I wondered if it was possible to reload or bring back a Userform once it has already been used.
For example, a Userform to create a letter might populate bookmarked sections of the letter with the text inputted into the various TextBoxes in the Userform. Often once the user has completed the Userform they press 'Submit' or 'OK' via a commandbutton, the letter is generated with the information selected / inputted in the Userform and the Userform is hidden.
However, where the user then notices mistakes or wants to make changes for whatever reason, would it be possible to 'reload' the previous Userform (with the users previously selected/inputted information) so that it could be altered and then resubmitted? The point being that much of the previous information will be fine and only a handful of things may need to be changed, so keeping the previous information to be amended in the Userform would save the user time rather than re-inputting good information.
I imagine if this is possible, it would potentially require the initial round of changes made by the first submission of the Userform to be undone?
Any thoughts would be great! :help
Thanks,
AJHEZ
I wondered if it was possible to reload or bring back a Userform once it has already been used.
For example, a Userform to create a letter might populate bookmarked sections of the letter with the text inputted into the various TextBoxes in the Userform. Often once the user has completed the Userform they press 'Submit' or 'OK' via a commandbutton, the letter is generated with the information selected / inputted in the Userform and the Userform is hidden.
However, where the user then notices mistakes or wants to make changes for whatever reason, would it be possible to 'reload' the previous Userform (with the users previously selected/inputted information) so that it could be altered and then resubmitted? The point being that much of the previous information will be fine and only a handful of things may need to be changed, so keeping the previous information to be amended in the Userform would save the user time rather than re-inputting good information.
I imagine if this is possible, it would potentially require the initial round of changes made by the first submission of the Userform to be undone?
Any thoughts would be great! :help
Thanks,
AJHEZ