See Debra Dalgleish's site for code.

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


Gord Dibben MS Excel MVP

On Tue, 15 Sep 2009 09:08:02 -0700, Vo_cha
wrote:

Ok so here is my issue:

I have a spreadsheet (outside deliveries) that I currently use a drop down
list via data validation to a named range (outside) on another sheet (outside
facilities) but the list font is way too small, and it would be easier for
the data entery if i could type part of the name verses trying to find on the
list. From what I know a combo box would probably be the best to incease the
font size as well ass allow me to type the first part of the name and find it
faster. Am I thinking along the right lines? I tryed to set it up but can't
get the combo box to use the vaildation information I have set-up. My head is
hurting and I don't know how to proceed. Can someone help please?