Hi,
I have an excel spreadsheet which has two activeX ComboBox's on it. The selection of the 1st ComboBox determines the ListFillRange of the second ComboBox by referencing named ranges called "Yes" and "No", when "Yes" is selected the 2nd ComboBox changes it's contents to the named range "YesServicePlus" and when "No" is selected it fills the contents with a named range called "NoServicePlus".
The problem is, my named ranges are entire columns, as the contents of these ranges are updated regularly by inexperienced excel operators (who I don't want redefining new ranges).This results in a lot of whitespace/blank rows at the end of the combobox list. Is there a way to removed this and only insert a ListFillRange with rows that actually have a value in them? meaning I don't have to specify the exact rows with data in them as my named range.
My VBA coce to fill the 2nd ComboBox is:
Code:
XtracareComboBox.ListFillRange = ComboBox1.Value
Any help appreciated.
Dan
Bookmarks