ericc
12-13-2007, 01:55 PM
Hello All
I have created a UserForm with a ComboBox for which the source is a named range.
Usually, it works nicelly but this time my range is horizontal (in a row) instead of vertical (in a column). And of course, I see only the first element of the list. In fact, if I put the parameter "ColumnCount" to 3 by example, I see 3 others values but horizontally :doh:(this is how I discover the problem).
I can solve this with a Copy then PasteSpecial/transpose on an other place of the sheet and then define the range from there. But I don't found this an "elegant" solution
Can you propose better ?
ericc
I have created a UserForm with a ComboBox for which the source is a named range.
Usually, it works nicelly but this time my range is horizontal (in a row) instead of vertical (in a column). And of course, I see only the first element of the list. In fact, if I put the parameter "ColumnCount" to 3 by example, I see 3 others values but horizontally :doh:(this is how I discover the problem).
I can solve this with a Copy then PasteSpecial/transpose on an other place of the sheet and then define the range from there. But I don't found this an "elegant" solution
Can you propose better ?
ericc