Latest Lists

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

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.

Public Comments

1. 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
2. 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