Are you asking how to concatenate values into a string to be passed as the
SQL command for the query.

sSQL = "Select name from table1 where field1 = '" &
worksheets("Sheet1").Range("A1").value & "'"

or something of that form.

--
Regards,
Tom Ogilvy


"jwilliamson" wrote:


I understand that I will need to do some coding, I just need to know
where to start. I have all the data I need in my query, how do I get
the query to use Cell A1, A2, A3... and so on to be a parameter for
that query. So that when the user types a value in A1, B1-I1 are filled
with the data from the query, and the same for A2, A3, etc...


--
jwilliamson
------------------------------------------------------------------------
jwilliamson's Profile: http://www.excelforum.com/member.php...o&userid=34493
View this thread: http://www.excelforum.com/showthread...hreadid=542593