Dawn

See Debra Dalgleish's site for instructions on adding a Combo-Box to a Data
Validation list.

The Combo-Box will allow auto-complete, which a DV list alone does not.

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


Gord Dibben MS Excel MVP

On Sun, 2 Apr 2006 13:15:02 -0700, Dawn wrote:

Hi

I have a drop down list which I would like to make it easier to use. How do
I get the cell which I choose an item from a dropdown list to let me put the
first letter of the word and it automatically jump down to that word?

Thanks

DAWN