VBA调用SQL中，条件语句的描述写法求助

cscnnn

假设材料条件是在 sht1.cells(1,1)，如果在下面SQL语句中调用sht1.cells(1,1)的值，在语句中要怎么表达？谢谢！

     cnn.Open Str_cnn
     Sql = "SELECT a.*,b.材料 as cisig FROM [产品1$] as a left outer join [产品2$] as b on (b.产品=a.产品 and a.材料 in (sht1.cells(1,1)))"
     Set rst = cnn.Execute(Sql)

lss001

Sql引用变量(x)形式：" & x & "，注意空格！代入即如下
Sql = "SELECT a.*,b.材料 as cisig FROM [产品1$] as a left outer join [产品2$] as b on (b.产品=a.产品 and a.材料 in (" & sht1.cells(1,1) & "))"

cscnnn

可以了，非常感谢！