I'm looking to create a UI for excel 2007 that allows the user to select drop down lists to narrow down a result. For example, I have address, city, and state. I want the user to be able to select a state from the drop down, then select the city from a list of cities in that state, then find the specific address or list of addresses based on my excel data.
I hope I explained this well enough. FYI I have little to know experience with VBA but I was messing around with the user form function so see what I could create, but this looks to be just for data entry, not data lookup/retrieval.
Bookmarks