Here's what I would do:

.tbBorr1Name.Value =
Range("Database").Find(What:=.tbBorr1CIF.Value).Of fset(0, 3).Value

You might want to rename database to be the first column of your
database to avoid finding records in other columns.

Let me know if that doesn't work.

Mark

Laz wrote:
*I still get the same error message. Any other ideas would be
appreciated.

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




*



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/