• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 463
  • Last Modified:

Repopulate userform from earlier entries / bookmarks

Hi,

I have made my life a lot easier using a userform and bookmarks to automatic populate  repeating text on contracts and documents in word.

But I would like to improve it a little.

After entries have been entered into the word document, I would like to open the userform again and have all the text that I wrote in earlier. If I do this now the fields in the userform are just blank and I must write in all the text again to make corrections. If I leave one blank it will erase the text where the bookmark are set.

So is it possible to repopulate a userform from your earlier entries?
0
Aage
Asked:
Aage
1 Solution
 
David Johnson, CD, MVPOwnerCommented:
I use something like evernote and have used other 3rd party applications to clip and paste i.e. activewords
0
 
Ken ButtersCommented:
You can save data from a userform into a document variable.

The next time you open the userform you can initialize the userform with data saved in the document variables.

The following link has examples for saving data into document variables and reading data back out of document variables.

http://support.microsoft.com/kb/306281

I would read from your documents variables in the forms intialization routine:
Private Sub UserForm_Initialize()
<< Read document variables here and store values in userform>>
End Sub

Open in new window

your userform also has a terminate routine that you can use to save the form data to document variables:
Private Sub UserForm_Terminate()
<< Save data from your userform to document variables here>>
End Sub

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now