Link VBA form fields to document form fields?

Question

Trying to automate a long form by using a VBA form with tabs to gather the information, then place it in the correct location Word field within the active document.

Is there an obvious/easy way to link the fields on the VBA form to those in the document? I know this is super-simple in Excel using the ControlSource property, but in Word 2003?

I have the AfterUpdate events circle back to each field with the changes, but that doesn't seem to visually update the underlying document quickly.

Thanks for any suggestions.

-jkitzy

Answer 1

See the following page of Greg Maxey's website :

http://gregmaxey.mvps.org/Create_and_employ_a_UserForm.htm

Normally, you would insert all of the data into the form and then use a command button to transfer it to the document, all in one go.

-- Hope this helps.

Doug Robbins - Word MVP,

dkr[atsymbol]mvps[dot]org

Posted via the Community Bridge

"jkitzy" wrote in message news:*** Email address is removed for privacy ***...

Trying to automate a long form by using a VBA form with tabs to gather the information, then place it in the correct location Word field within the active document.

Is there an obvious/easy way to link the fields on the VBA form to those in the document? I know this is super-simple in Excel using the ControlSource property, but in Word 2003?

I have the AfterUpdate events circle back to each field with the changes, but that doesn't seem to visually update the underlying document quickly.

Thanks for any suggestions.

-jkitzy

---

Doug Robbins - Word MVP dkr[atsymbol]mvps[dot]org