data in form Combobox2 depends on selection from Combobox1

Originally Posted by Tinbendr

What you are describing is called cascading combobox/listbox.

There are dozens of examples on the net.

But, I'm feeling generous today and have provided an example.

Basically, you search for the team column header and fill combobox until lastrow.

This code is dynamic, both on teams names and member names, meaning the list can change without modifying the code.

David, appreciate your generosity. What you produced is more or less what I am trying to achieve, however, I was looking to do this within the worksheet using the form combobox. I created the form comboxbox from the toolbar not in VB userform. I apologise if I was not clear enough. Your example has certainly given me another perspective on things and may explore that at another time but for now i want to keep things within the worksheet.

Again, I have it working as a Active-x comboxbox but given the issues with external monitors/projectors etc I want to see if the same can be achieved with regular form comboxes.

I have updated the worksheet you sent to illustrate what I am looking for, it should be much easier to understand if you look at the attached worksheet
1006634-Cascading comboboxes(2).xlsm

Originally Posted by Tinbendr

Here's all solutions. (Forms are a pain in the ****.!)

You nailed it! Only thing missing is how to output the value in ComboBox2 to a cell, J11 for example. I right click on ComboBox2 and added a cell reference but it only gives the index number and not the text value.

Can you advise of a VB string I could use? I tried some but maybe I am not adding it in the right place in your code

Right after this line "Sheet1.ComboBox2.AddItem .Cells(A, C.Column)" I added the following but it didnt work:

J11 = ComboBox2.Value

Thanks!

Originally Posted by Tinbendr

Either one of these in the Combobox1_Change event

Please Login or Register  to view this content.

(Or manually right -click, properties, Link to cell J11

Just for prosperity, I edited the file once more to fix a couple of things and to add values to sheet.

Thanks! it works as expected. Appreciate your efforts

Starting to feel a little rude with the extra question. I was copying your code to my worksheet and I just realised my tables with teams and people are in another sheet from where the ComboBoxes will be.. the sheet for the team names and people is called NOTES and sheet with ComboBoxes is called Global Talent

The data is laid out exactly as you had it in your sample worksheet Column A for teams and B through F for the people.

Is it simple enough to add the sheet name in all the right places? You have already been a great help and I would really appreciated your guidance on this.

thanks,

Originally Posted by emortals

Starting to feel a little rude with the extra question. I was copying your code to my worksheet and I just realised my tables with teams and people are in another sheet from where the ComboBoxes will be.. the sheet for the team names and people is called NOTES and sheet with ComboBoxes is called Global Talent

The data is laid out exactly as you had it in your sample worksheet Column A for teams and B through F for the people.

Is it simple enough to add the sheet name in all the right places? You have already been a great help and I would really appreciated your guidance on this.

thanks,

I seem to have worked it out.. I could not use a space in the sheet name and I added in infront of the .Cells and .Range Worksheets("NOTES")

Thank you for your kindness to help me achieve this task!!