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
there are also unknown unknowns. There are things we don't know we don't know."
----- Original Message ----
From: Laoballer <[EMAIL PROTECTED]>
To: MS Excel & VBA Macros <excel-macros@googlegroups.com>
Sent: Wednesday, 24 September, 2008 4:51:27 AM
Subject: $$Excel-Macros$$ 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
Unlimited freedom, unlimited storage. Get it now, on
http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
