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