Excel - (Data Validation) ListBox Height

[xlhelp]

Hi.

Does anyone know if there is a way to increase the listbox height. I have 10 items to choose from, listbox shows only 8. I have searched, but have had no joy, so far. (XL 2003)

A man has only two choices: He can be right or he can be happy.

 

[Mizzness]

XL,

Does your List Box contain all 10 items ?
If so you can just resize the box by righ-clcking on the box and dragging down one of the corners.

 

[xlhelp]

I so wish it was that simple.

So far the only thing I have found is overlaying a Combo box on top of the list box. But, that's more pain than is necessary.

A man has only two choices: He can be right or he can be happy.

 

[Mizzness]

Hmmm...seems strange.

Why not just create a new List Box ?
Based on your example I tried it and it worked fine.
Have you checked the range of your list ?

 

[SkipVought]

He's not using a ListBox. It's a Data > Validation - In-Cell DropDown Not the same!

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]