validation lists & drop-down menus

[davedog]

hi--

i'm working w/ excel 2002.

in the image below i have an example picture.

i am creating a list of items, ie fruit.

and i am using validation to limit a cell's contents to an item fro
the list.

QUESTION: is there a way to increase the size of the drop-down men
listing? ie: increase the font size of the items? or increase th
number of viewable items when you pull down the list (say to 10 or 2
items in the viewable range)? also, is there a way to have th
possible selections pop up as you type in? ie: if i type m into th
box, it will automaticlaly show me "mango" as a possibility?

thank you for your help

+-------------------------------------------------------------------
|Filename: excel.JPG
|Download: http://www.excelforum.com/attachment.php?postid=3759
+-------------------------------------------------------------------

 

[Debra Dalgleish]

If you can use programming, there are instructions here for adding a
combobox from which you can select one of the values from the data
validation list. In the combobox, you can enable autocomplete, and
change the font size and list length:

http://www.contextures.com/xlDataVal11.html

 

[Gord Dibben]

Davedog

DV lists are quite restrictive. Most of the points you raise cannot be done
using DV drop-downs.

Best you use a combo-box which can be resized and re-fonted.

See Debra Dalgleish's site for this.

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

If need more on DV, hit Home when at the above site then scroll dow to DV
items.


Gord Dibben Excel MVP

\On Mon, 29 Aug 2005 14:06:57 -0500, davedog