$$Excel-Macros$$ Re: listbox in excel that is an option for sql query

 Checkout indirect function in excel help. _ "There are known knowns. These are things we know that we know. There are known unknowns. That is to say, there are things that we know we don't know. But

$$Excel-Macros$$ Re: listbox in excel that is an option for sql query

I assume that you would implement these list boxes in a user form. In that case you can use, the Jet OLEDB Provider For Microsoft Excel Databases, to query an XLS file. Below is the code snippet to use. The code demonstrates how to use Jet OLEDB Provider For Microsoft Excel Databases. You need to