OK this worked; but only if cf_detail.xls is the active workbook. How can i
code the vlookup part of the code (arg #2: range to look in) so that
cf_detail.xls does not need to be the acitve workbook?

I change it to ..........Range("Database") and it only works if
cf_details.xls is the active workbook. This workbook will not be the active
one. It looks as if I need to quality the Range("Database") whose syntax I
do not know.



Thanks in advance for the help!
Laz

"Tom Ogilvy" wrote in message
...
You would need to open cf_details.xls

--
Regards,
Tom Ogilvy

"Laz" wrote in message
...
I'm having a difficult time with the syntax to be able to populate
textbox
controls in a userform using VLookup with data in a worksheet outside of
the
userform .

Can anyone help? Is it even possible to code this in VBA?

I'm using something like this in a standard module:

Dim UF as Userform
Set UF = UserFormLoanReqInpute

with UF
.tbBorr1Name =
application.worksheetfunction.vlookup(.tbBorr1CIF, ("C:\My
Documents\cf_details.xls!Range("Database"),3,false )

I get error #1004

Please help as I need to complete this project ASAP!

Thanks . . . . . Laz