Excel validation drop down list

[disturbedone]

Hi, I have a sheet with cells that are higher than they are wide (w3 x h14). The cell is formated to have the text written bottom to top. I have set the cell to validate against a list of things elsewhere in the page but the drop down list only shows part of the names that are in the list because of the width of the cell. Is there a way of making the list appear wider than the cell actually is?

Thanks

 

[SkipVought]

Hi,

Not with a Validation DropDown AFAIK. You could use a Combobox Control, but then you'd need some VBA code to manage that.

Skip,

_[red][/red]