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
>
>