Thread: Multiple Prompts

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.