dependent combo box

Hello All, I have a independent combobox and a dependent combobox, the dependent combobox depends on the information provided in the first independent combobox. I know there is the select case to make fill the dependent combobox. Here is a brief overview what my code does. I have two...

Hello! This is my first post to the forums, though I've appreciated many tips and tricks posted here in the past. I'm rather new to coding VBA, but have a basic understanding of coding in general along with lots of patience and determination. Now on to my problem: I'm trying to create an...

I have been using Case statements to create dependent drop down lists for combo boxes with success. I have a combobox dropdown to select appliance brand cmb.appbrand with pulls from rowsource= "Appliance_Brand". The very next drop down combobox is to select the color cmb.appcolor.rowsource =...

I'm creating a dependent drop down box using ComboBoxs. I have a total of 3 boxes dependent upon the previous. I've written the below so far but it's not working. When I select the item in the 2 drop down it doesn't appear in the drop down. Or (If i take out the .clear from below) the list...

I know the easiest way to do a dependent drop down is with Data Validation. However, the options in my lists are too long to use this (unfortunately, I cannot make them shorter.) I need to be able to create a 2 dependent drop downs (total 3 that cascade depending on the selection.) I was...

Hi, first I want to thank you in advance for helping me out. I have developed a user form in excel. I have 2 combo boxes. The first one is Manager and the second one is Employee. Upon form initialize I populate all Managers and Employees from excel tabs with the code below (this populates...

Hi, first I want to thank you in advance for helping me out. I have developed a user form in excel. I have 2 combo boxes. The first one is Manager and the second one is Employee. Upon form initialize I populate all Managers and Employees from excel tabs with the code below (this populates...