VBA Open and Insert User Form Textbox Inputs into Word from Excel

Hi,

Certainly is possible.

The easiest way is to set up bookmarks in your Word template - that way it's easy to locate where the relevant values need to be put in.

Have a look at post #2 on this thread to get you started:
http://www.mrexcel.com/forum/showthread.php?t=358054

HTH
Colin

There are 2 methods that come to mind: Formfields and Bookmarks in your doc file. See this link for an example.

Thanks so much for the quick reply. I couldn't get the form fields to work. Below is my code. I need to find "<1>" and replace it with CustomerName.Input from a userform in Excel. I tried doing a find and replace but couldn't get that to work either. I really really appreciate any help!

Dim objWord As Object, wd As Object
Set objWord = CreateObject("Word.Application")

Set wd = ObjectWord.Documents.Open("W:\Accrual Programs\QPP & SA Contracts. Contract Traveler\FOR EXCEL USE ONLY.doc")
ObjectWord.Visible = True
ObjectWord.Selection.Find.ClearFormatting
ObjectWord.Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = "<1>"
.Replacement.Text = CustomerNameInput.Value
End With
Selection.Find.Execute Replace:=ObjectWord.ReplaceAll

Anyone? Please? I would really appreciate it. I can't seem to figure it out. Thanks!

Oh, so you want to do it in a 3rd way? Ok, the best way is to start by recording a macro in MSWord just as we would in Excel. As you can see from this example, you need to Execute the Find/Replace.

Since you are doing it in MSWord, you will have to prefix Selection with your wd object for the document. The wdReplaceAll will need a prefix, wdreplace, wdreplace.wdReplaceAll.

Tip: Use the Tag property for your textbox controls. This will let you iterate all the textbox controls in a loop.
e.g.

The first step would be to get one textbox value inserted. We can always work on the Tag loop later.

Tip2: You can use early binding to make coding easier. e.g.

Great. I got it to work. Thank you so much for your help!