Is there a reason you're not using it as a worksheet function. One of the
problems with this function is if you change something in C10:e25 of that table
workbook.

The function doesn't know you're using that range. So it won't recalculate.

I'd use the native excel function with in the worksheet, but if you don't want
to, then add:

application.volatile

at the top of your subroutine.

(Hit F9 before you trust your output to force a calculation.)

ChachiAZ wrote:

I need some help. I have "zero" VB skills. I got this function from
Microsoft's Web site ...and it works perfectly with the exception it
outputs to a MsgBox. I need the output to go to a specific cell.
Actually, I need it to output to the active cell I called the function
in. Currently only get the message then the cell fills with 0. Any
ideas?

Function test(x)
MsgBox Application. _
VLookup(x, Workbooks("test_of_vlookup.xls"). _
Worksheets("Sheet2").Range("C10:E25"), 3, False)
End Function

I attached a workbook. If you click on Sheet1!D25 you can see the
MsgBox in action.

+----------------------------------------------------------------+
| Attachment filename: test_of_vlookup.xls |
|Download attachment: http://www.excelforum.com/attachment.php?postid=349894|
+----------------------------------------------------------------+

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

--

Dave Peterson