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

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

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

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

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/