listbox in excel that is an option for sql query

L

Laoballer

I have a set of data that looks like this

STATE CITY
OR Portland
OR Beaverton
WA Seattle
WA Olympia
WA Spokane
CA Los Angeles
CA San Diego
CA San Jose

What I would like to be able to do is have 3 list boxes, the first one
would contain the State abbreviation, OR,WA,CA
which I can multiselect and then the 2nd listbox would populate with
all the city's that belong to the states chosen. These two would be
in a where clause of an sql statement that I would query a database to
return data that populates the 3rd listbox. How would I go about
doing this?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

list box in excel as option for msquery 0
Address's in Word document into Excel 0
Excel 2010/2007 - How much can be done with Custom Validation? 7
Automatic Filtering 4
Parsing Address, City ST ZIP 7
How to use dynamic query in Access 2007 Form? 3
Query involving Strings : How To Return Matching Data From Both Ta 4
USING SQL STMT FOR QUERY 2

Top