Is this possible with a listbox?

A

Ayo

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.
 
K

Kassie

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top