HI
I have added 2 combo boxes to a spreadsheet. The 1st is used to select a BU and the second is a dependant drop down for selecting a sub BU based on the BU chosen in combo box 1. I have used this sort of set up before and it has worked fine.
However, ComboBox2 doesn't seem to display the rows correctly when clicked. It is showing some or all of the list then several balnks followed by 1 or 2 duplicate values from the list. I have a screenshot but can't work out how to attach it??
The list fill range is a dynamic named range within the workbook. I am using vba to carry out an advanced fiter when ComboBox 1 changes so that the list fill range for ComboBox 2 shows a list of relevant sub BUs. All looks ok with the lists and named range. Seem to be display correctly on the worksheet but still I get the blanks and duplicates in the dropdown.
List rows also varies dependant on the number of rows in the list fill range. I am again using VBA to change this value when ComboBox 1 changes. When I check the properties of ComboBox 2 after each change, it is shwoing the correct value for List rows, however, the actual dropdown has more rows due to the duplicate and blanks.
I don't think this is imapcting the functionality of my workbook but it is more cosmetic and this is due to go out to a wide audience so I'd like to get the issue resolved.
Many thanks
p.s. if someone can tell me how to attach a file I will add in my screenshot
I have added 2 combo boxes to a spreadsheet. The 1st is used to select a BU and the second is a dependant drop down for selecting a sub BU based on the BU chosen in combo box 1. I have used this sort of set up before and it has worked fine.
However, ComboBox2 doesn't seem to display the rows correctly when clicked. It is showing some or all of the list then several balnks followed by 1 or 2 duplicate values from the list. I have a screenshot but can't work out how to attach it??
The list fill range is a dynamic named range within the workbook. I am using vba to carry out an advanced fiter when ComboBox 1 changes so that the list fill range for ComboBox 2 shows a list of relevant sub BUs. All looks ok with the lists and named range. Seem to be display correctly on the worksheet but still I get the blanks and duplicates in the dropdown.
List rows also varies dependant on the number of rows in the list fill range. I am again using VBA to change this value when ComboBox 1 changes. When I check the properties of ComboBox 2 after each change, it is shwoing the correct value for List rows, however, the actual dropdown has more rows due to the duplicate and blanks.
I don't think this is imapcting the functionality of my workbook but it is more cosmetic and this is due to go out to a wide audience so I'd like to get the issue resolved.
Many thanks
p.s. if someone can tell me how to attach a file I will add in my screenshot