Populating combobox based upon cells having any value

[jaredmccullough]

I have the following code which set sets the row range based upon Combobox1.Value

Please Login or Register  to view this content.

What I need is some finishing code which will populate Combobox2 based upon information from the row combobox 1 has taken it to.

Search Column Q for value:

If no value and column E = "A", "B", "C" then populate comboxbox2 with "Host"
If no value and column E = "D", "E", "F" then populate combobox2 with "Agent"
If value then do not populate combobox2

Search Column R for Value
If no value and column E = "A", "B", "C" then populate combobox2 with "Buyer"
If no value and column E = "D", "E", "F" then populate combobox2 with "Engineer"
If value then do not populate combobox2

Search Column s for Value
If no value and column E = "A", "B", "C" then populate combobox2 with "Person"
If no value and column E = "D" then populate combobox2 with "Artist"
If value then or no value and Column E = "E", "F" do not populate combobox2

Search Column T for Value
If no value and column E = "A", "B", "C" then populate combobox2 with "Example"
If no value and column E = "D", then populate combobox2 with "Worker"
If value then or no value and Column E = "E", "F" do not populate combobox2

Thanks for any help in advance.

[GC Excel]

Hello jaredmccullough,

I believe this will work (not tested) :

Please Login or Register  to view this content.

[jaredmccullough]

Hello jaredmccullough,

Thanks GC because this code is dependent on combobox1 value how would you suggest having it activate? Is there a way to have it run when the user clcks onto combobox2 and if so is there a way to make the display of the combobox say like "Select here" until the combobox is chosen?

[GC Excel]

Difficult to answer without seeing the rest of your code.
You could use an event triggered when the combobox1 is changed :

Please Login or Register  to view this content.

[jaredmccullough]

GC Worked perfect (2) questions though:

1.) Is there a way to have initial text in the combobox to guide the user like "Select Here" or something
2.) Now if I wanted to use a combination of a commandbutton and textbox to return a value to the cell chosen in combobox2 (i.e. combobox1 picks the row and combobox2 is essentially setting the cell as it is using columns). How would one approach that?

[jaredmccullough]

GC Worked perfect (2) questions though:

1.) Is there a way to have initial text in the combobox to guide the user like "Select Here" or something
2.) Now if I wanted to use a combination of a commandbutton and textbox to return a value to the cell chosen in combobox2 (i.e. combobox1 picks the row and combobox2 is essentially setting the cell as it is using columns). How would one approach that?

[GC Excel]

1) you could put a label on your form next to/above combobox2 and make it visible when combobox1 is changed.

Please Login or Register  to view this content.

2)Difficule again to answer without seeing your workbook but if I understand well, on your button:

Please Login or Register  to view this content.

Note: You would have to define rng as a module variable.

[jaredmccullough]

1) you could put a label on your form next to/above combobox2 and make it visible when combobox1 is changed.

Please Login or Register  to view this content.

2)Difficule again to answer without seeing your workbook but if I understand well, on your button:

Please Login or Register  to view this content.

Note: You would have to define rng as a module variable.

1) you could put a label on your form next to/above combobox2 and make it visible when combobox1 is changed.

Please Login or Register  to view this content.

2)Difficule again to answer without seeing your workbook but if I understand well, on your button:

Please Login or Register  to view this content.

Note: You would have to define rng as a module variable.

GC,

I did not perform enough testing on the previous code: Essentially you will see the code was modified with actual terms and the columns were adjusted one over. The problem is it is not populating the combobox with all values just the last one from the code. (See example of "insurance" if column R and S were empty it should provide both values in the combobox.

Please Login or Register  to view this content.

[GC Excel]

If you want to populate the combobox will all possible values, then instead of having :

Please Login or Register  to view this content.

Use this :

Please Login or Register  to view this content.