I have several cells in a sheet assigned to show a list of info using the
"Validation" "List" options.
When you click on the cell a dropdown list appears of info to choose from.
It works fine but........
It only showns 8 lines. Then you have to scroll the drop-down list.
How do I make it longer, showing prehaps 15 or 20 lines so I do not have to
scroll in the dropdown?

Rich / Thank you!

Debra Dalgleish has some techniques he

http://www.contextures.com/xlDataVal08.html#Larger

Hope this helps.

Pete

"Inspectec Rich" <Inspectec wrote in message
...
I have several cells in a sheet assigned to show a list of info using the
"Validation" "List" options.
When you click on the cell a dropdown list appears of info to choose from.
It works fine but........
It only showns 8 lines. Then you have to scroll the drop-down list.
How do I make it longer, showing prehaps 15 or 20 lines so I do not have
to
scroll in the dropdown?

Rich / Thank you!

I think Pete meant to use this link <g:

http://www.contextures.com/xlDataVal08.html#Font

It contains a link to instructions for using a combo box. With a combo
box, you can change the list length.

Pete_UK wrote:
Debra Dalgleish has some techniques he

http://www.contextures.com/xlDataVal08.html#Larger

Hope this helps.

Pete

"Inspectec Rich" <Inspectec wrote in message
...

I have several cells in a sheet assigned to show a list of info using the
"Validation" "List" options.
When you click on the cell a dropdown list appears of info to choose from.
It works fine but........
It only showns 8 lines. Then you have to scroll the drop-down list.
How do I make it longer, showing prehaps 15 or 20 lines so I do not have
to
scroll in the dropdown?

Rich / Thank you!





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html