parameter has multiple values seperated by value
 

my MSquery
select *
from products
where productname in ('printers', 'fax', 'chairs')


My product names are a range of cells in a worksheet. The list of product
names I want is a dynamic or user-entered list and can be 2 or 3 or upto 40
names. Can the msquery be parameterized ? I do not want to go for
SQL.REQUEST or programming in VBA.

Can any one has any hints ?