Populate a second combo box based upon the first one....

[MattyT200]

Greetings

I'm new to the forum and learning a lot from all your posts, thank you for that if nothing else becomes of this request. I would like to understand how to fill a second combo box based on the selection of the first one. For example if I select a part in column B as 0005-2431 (which there are two entries) I would like the second combo box to show me the information in column P. Any help on the coding would be greatly appreciated....

Thanks
Bob

[mehmetcik]

I answered this in a recent post.

Study that and come back if you need more help.

http://www.excelforum.com/excel-prog...ml#post3853175

[MattyT200]

Thank very much for your very quick response. With my limited experience compared to your 20 years I have found an apparent difference that I didn't highlight during my original post. My column A can have duplicates (variations on the same part) and Column B would highlight the each of these variations. Dont see that working your example. Does that make sense?

[mehmetcik]

Post a copy of the combobox data.

If you had loaded your data in my format, you would have found that variations are supported.

Post your data and I will format it for you.

[MattyT200]

Hi here a sample of the data....column 1 is the data for combo box1. The results based on column1 will come from column two

Thanks

[MattyT200]

Sorry this is the correct file

[mehmetcik]

Try This File