How do you link multiple lists drop down lists in excel 2003?

Question

I need to link 3 drop down lists to read in line in three different columns.  Headers are #, information, and task performer which will always be the same.  (ie.  #1, wash the car, Jack; #2, refuel the trucks, Tom; etc.)  

I know its probably something really simple, but I'm just not finding the answer anywhere.

VBAXLMan · Accepted Answer

Here is a lesson for doing Validation-based on-Validation
http://file1.net/lesson.asp?id=x06f7J2UUPw6aVLP

And the file that is doing that is here
http://file1.net/project.asp?id=dxkbm07CwF057

Enjoy them

VBAXLMan is back to fill your Excel needs

Anonymous · Answer

I have to assume this is in VBA or something like that. You need to put in a handler for the select changed event for the drop down lists. When you get it for one, change the index in the others to match.

See references below. These may not be directly for your environment but you will have similar properties and events in 2003.

For setting/getting index:
http://msdn.microsoft.com/en-us/library/system.windows.forms.combobox.selectedindex(VS.80).aspx

For handling the event: 
http://msdn.microsoft.com/en-us/library/system.windows.forms.combobox.selectedindexchanged(VS.80).aspx

daniel · Answer

You could use a vlookup formula. So, in another table (same sheet or another sheet) you have all the Countries and Currencies. Then use a vlookup so that when you select a country, it searches for that country's currency in the table.

Trending News

How do you link multiple lists drop down lists in excel 2003?

3 Answers