I have a few comboboxes in my workbook which work wonderfully, however.....
They all take their ListFillRange from named ranges arranged vertically in a column.
The new combobox needs the ListFillRange to be taken from a range held horizontally - 'Simples' I thought, a range is a range afterall....
I have the ListRows set at 20, however the only option for selection is the first cell of the horizontal range and it's only the first item from the list.
Is there some limitation around lists only being stored in columns or is there a workaround?
Cheers.
Bookmarks