Where is the name of the customer  kept?

It's in the Sheets "Customer Master"

Column 1 contains the customer  Code
Column 2 contains the Name of the customer

And in a form I am asking the user to select the customer Code and upon
which the Name of the customer should reflect in Textbox.

did you ever get this to work? I am trying to do almost
the exact same thing (see my question "Searching Excel from Word"),
but am really strugling getting it to work. Any info you received
that you could pass on to me would be much appreciated.

Private Sub CboNodeid_Change()
With TxtNodeDescription
If CboNodeid.Value = "" Then
TxtNodeDescription.Value = ""
Else
TxtNodeDescription.Value = Application.VLookup(CboNodeid.Value,
Range("nodedetails"), 3, False)
End If
End With
End Sub

this is my code  to do the same

thanks for sharing how you do it, but I still can't get it to work. The
only other code  I have are the two lines below:

Dim myWB As Excel.Workbook
Set myWB = GetObject("D:\AORP Project\Form vlookup  Example.xls")

With the 2 statements above, I can reference a cell with the statement below
and it works great.

MsgBox myWB.Worksheets("Sheet1").Range("A2").Value

However, as soon as I try the application.vlookup....I get a run time error.
What am I missing? It has to be something very simple, but I am lost.

A perfect example of what I am trying to do is simply take the very simple
"Form VLookup Example.xls" file that contains about 5 lines of code located on
the Excel Group and make it work with a Word Userform instead of an Excel
Userform.