Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can rights to run but not create a query in excel an option? | Excel Discussion (Misc queries) | |||
where is the create OLAP cube option from microsoft query? | Excel Discussion (Misc queries) | |||
Using a ListBox selection to query a database | Excel Discussion (Misc queries) | |||
Uisng an option group query | New Users to Excel | |||
Listbox Query Again | Excel Discussion (Misc queries) |