Custom Dialog Box - Getting user input.

[Guest_imported]

With a simple Custom Dialog Box, how do I get user input onto my word document? I have three user filled text fields that i need to transfer onto a table in Word 97. (I do not want to use the standard Input Box.)

 

[avrcan]

Look at

http://www.vbatutor.com/vbatutor.htm.

There you will find everything you are interesting in.

 

[SlyBoots]

Let's say you have userform1 with three text fields named txtField1, txtField2, and txtField3. Put a button on the userform, and link it to code like this:

Sub CommandButton1_Click()
ActiveDocument.Bookmarks("bkm1&quot.Range.Text = Me.txtField1
ActiveDocument.Bookmarks("bkm2&quot.Range.Text = Me.txtField2
ActiveDocument.Bookmarks("bkm3&quot.Range.Text = Me.txtField3
Unload userform1
End Sub

Stan
You don't need bookmarks, of course. You can reference your document any way you like. But this shows how to reference the userform fields.