Combo Box populate column

[SCWilly1]

Hi Everyone,

I have a quick question regarding combo boxes...and I may have to use VBA.

I want to have users select a value i.e. Fish from a down box. Once the user selects fish all instances for fish populate i.e. Trout, Salmon, Tuna, etc. in the adjacent column.

The list of fish can be in the same workbook or a different workbook as well as the value.

Thanks in advance for all of your help!!!

[Ron Coderre]

See Debra Dalgleish's coverage of Dependent Lists at her Contextures website:
http://www.contextures.com/xlDataVal02.html

Does that help?

[SCWilly1]

Hi I've been to the contextures website before but I still need help with figuring out how to return a series of values that are not in a drop down list once a value is selected.

If I selected fish from the drop down...I would like to see a list of names/values populated to the side...I don't want to be able to select what type of fish I just want a completed list that looks like text in each cell.

I have attached a file to show what I need.

Thanks,

[Ikaabod]

I don't think you attached a file as you indicated... here's what I have for you given the information you did give though. See attachment. It may not be the prettiest code, but it works. Let me know if you need any modifications.

[SCWilly1]

Hi Ikabod that works sort of but now I need the list to have unique values in your example under Fish you had Guppy, Flounder, etc. but what if I have 2 guppies and 14 salmon in my list how do I have that only represented once with your code?

Thanks so much!!

[SCWilly1]

Also in the Fish column I would like the information to run down the column in the drop down so if someone selected salmon they could see all the expamles in the examples column like Sockeye, Chinook, etc.

Thanks!!

[Ikaabod]

Didn't know you would have duplicates. This should fix that issue. Let me know if there's anything else. Attached revised spreadsheet.

[Ikaabod]

Also in the Fish column I would like the information to run down the column in the drop down so if someone selected salmon they could see all the expamles in the examples column like Sockeye, Chinook, etc.

This sounds a bit more complicated than your original request. Could upload your existing spreadsheet or a good test sample? Remember to zip the file since these forums don't accept straight .xls files.

[SCWilly1]

Hi Ikaabod,

We're almost there I want to be able to select Salmon in column A and have the species of salmon in Column B populate.

I have attached a updated workbook.

Thanks again,

[Ikaabod]

I see what you're trying to do.

Is there always ONLY going to be those two columns? If so, I could really simplify the code.

Expect an update by tomorrow! Til then, have a good one.

[samtwilliams]

If you have a cell that has a list of all your fish say "A1"

When a user selects their fish in A1 populate all fields below with information about that fish.:

Create a table with all the information. Column 1 Being Fish Name and further columns being the information.

Please Login or Register  to view this content.

So say if you want the colour of the fish in A2. Insert the above code into that cell. That will then search the Fish table depending on what the user selects in A1, and display the information found in column 2 in cell A2.

Hope this helps

[SCWilly1]

Can you send a workbook example?

[Ikaabod]

The more I'm looking at this the more it seems like all you need is a pivot table. I've not spent a lot of time working with pivot tables, but I'm able to come up with a really simple one that gets the job done in a slightly unorthodox way. If someone knows a better way using a pivot feel free to chime in.