ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   listbox in excel that is an option for sql query (https://www.excelbanter.com/excel-discussion-misc-queries/203647-listbox-excel-option-sql-query.html)

Laoballer

listbox in excel that is an option for sql query
 
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


All times are GMT +1. The time now is 01:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com