How to add the data entered in a userform into a Text Form field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sujitg - 15 Mar 2007 19:55 GMT

Hi,
I am very new to VBA, and word macros ( learning with the help of this forum
and Diane Chapman's tutorials).

I created a userform and want to populate the contents of a text Form field
on the word form with data entered in the userform.

How do I do it?

Essentially how do I append the values to the textForm field from the
userform?

Plz let me know if I need to explain what I am trying to do mor eclearly,

Thanks for your help

Sujit

Reply to this Message

Greg Maxey - 15 Mar 2007 21:03 GMT

Using your excute command button, use code similiar to this:

Private Sub CommandButton1_Click()
Dim oFF As FormFields
Set oFF = ActiveDocument.FormFields
oFF("Text1").Result = Me.TextBox1.Text
oFF("Text2").Result = Me.TextBox2.Text
Unload Me
End Sub

> Hi,
> I am very new to VBA, and word macros ( learning with the help of this forum
[quoted text clipped - 13 lines]
>
> Sujit

Reply to this Message