Application.WorksheetFunction

[Akinbode]

What is the procedure to resolve the following issue:

Run-time error '1004':
Unable to get the VLOOKUP property of the WorksheetFunction class

Clicking on Debug highlighted the following line of code
Me.txt_Rate.Value = Application.WorksheetFunction.VLookup(Me.cmb_Product, sh.Range("B:D"), 2, 0)

Any assistance wil be highly appreciated.

Kind regards.

[CheeseSandwich]

Just a guess:

Please Login or Register  to view this content.

Is the value there to be found or could it be missing?

[JohnTopley]

Please see yellow banner on how to post a sample workbook.

[Marc L]

As WorksheetFunction is useless except to crash the procedure, remove it
and use a Variant variable then check the result via IsError for example ...

[Akinbode]

Thanks for the response. The record actually added to the required excel worksheet. But the error keep coming up each time a new record is added.

[Marc L]

Keep Application, remove WorksheetFunction. and check the result ...

[mikerickson]

There is a difference between WorksheetFunction.VLookup and Application.VLookup.
If the search term is not there, WorksheetFunction.VLookup causes a VB error and crashes, like your situation.

But Application.VLookup will not crash, it will return a value of data type Error

Please Login or Register  to view this content.

[Marc L]

Like post #4 ...