Hi Dave,

I need the application application.inputbox to get the file since the range
will not change and will be set.
--
Regards,
Jeff



"Dave Peterson" wrote:

Maybe...

But then you'd have to rely on the typing of the user.

Maybe you could use application.getopenfilename to retrieve the filename, then
open that workbook, then use application.inputbox to get the range out of that
workbook.

Another option if the address/worksheet names/workbook names/folder names don't
change.

Make a list with all the options, put it into a combobox. Let the user select
from that list.

Jeff wrote:

Hi,
Is it possible with VBA to enter the Table_Array of a Vlookup with an
Inputbox?
My problem is that the vlookup that I run needs a table_Array that could
resides in several directories.

--
Regards,
Jeff

--

Dave Peterson