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.