Hi!

I don't think you can do anything to change the number of
items displayed in a dropdown. An alternative would be to
use a listbox in which you can display as many items as
you want based on the size of the listbox. A drawback is
that unlike a dropdown list, the listbox is always visible
and requires a linked cell to display the selection made.

Biff

-----Original Message-----
OK - to be more clear - I'm asking about the number of
items displayed in the
list when it 'drops down". The list I'm using is about
200 items long, and
you can scroll down to see all of them, but my users find
the short display
harder to use. Can you DISPLAY more than 7 at a time?
jlb

"anilsolipuram" wrote:


list appears to be about 7 items from the list,
- no it doesnot take 7 items only, there is no limit to
number of items
it can take


--
anilsolipuram
--------------------------------------------------------
----------------
anilsolipuram's Profile:
http://www.excelforum.com/member.php?
action=getinfo&userid=16271
View this thread:
http://www.excelforum.com/showthread...hreadid=313969


.