Not using a Data Validation list dropdown.

You can use a combo box instead and get a larger size and other features.

See Debra Dalgleish's site for instructions.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP


On Thu, 14 Jun 2007 08:40:02 -0700, cliffordjf
wrote:

I am doing some entry validation using a list. Only part of the list shows
up due to the size of the drop-down box that appears and requires the user to
scrolll. Is there a way to adjust the size of the drop-down box so the whole
list is visable without scrolling?

thanx