Is this possible with a listbox?
While you can use merged cells, this makes for a very ugly list, full of
empty rows, especially if you have a horizontal list, using horizontally
merged cells! I don't know why people merge cells, other than to see
content! Excel certainly does not have to "see" the content. You can have a
12 digit name in a column showing 3 digits, and Excel reads it correctly
every time.
To use a horizontal list, merley define that horizontal list in the Source
box eg A1:K1
--
HTH
Kassie
Replace xxx with hotmail
"Ayo" wrote:
Is it possible to use merged cells in a ListFillRange property assignment for
a listbox or do I have to create a new list without the merges to populate my
listbox?
Also how do you use a row list in a listbox? In other words, I have a list
in Range("D3:AA3") that I want to use in a listbox.
|