QueryTable Lookup
 

I am trying to populate Excel comboboxes (or something similar) from data in
Access. By scouring the internet, I found out about QueryTable and I have
written code that will return the results of a query onto an Excel sheet. I
would like the results to go to comboboxes. Here is what I have:

Set varQuery = ActiveSheet.QueryTables.Add(Connection:=varConn,
Destination:=Range("a1"), Sql:=varSql)
varQuery.Refresh

Any help is appreciated. Thanks.