Is there a way to prompt the user for mulitple criteria for a query in Excel.
For instance, we want to prompt the user to enter a series of zipcodes and
use the list for the query.

Thank you.

Untested, but I would think You would concatenate a string of zipcodes into
an
sql string like below (partial)

v = "22032,63124,22334,55444"

.. . .

" . . . where tablename.zip In (" & v & "), . . . "

obviously you could prompt with in input box.

--
Regards,
Tom Ogilvy



"jberv534" wrote:

Is there a way to prompt the user for mulitple criteria for a query in Excel.
For instance, we want to prompt the user to enter a series of zipcodes and
use the list for the query.

Thank you.

The input prompt did not recognize the entry. Thanks for the help, anway.

"jberv534" wrote:

Is there a way to prompt the user for mulitple criteria for a query in Excel.
For instance, we want to prompt the user to enter a series of zipcodes and
use the list for the query.

Thank you.

The input prompt did not recognize the entry.

What does that mean?

--
Regards,
Tom Ogilvy


"jberv534" wrote:

The input prompt did not recognize the entry. Thanks for the help, anway.

"jberv534" wrote:

Is there a way to prompt the user for mulitple criteria for a query in Excel.
For instance, we want to prompt the user to enter a series of zipcodes and
use the list for the query.

Thank you.