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 <Dawn@discussions.microsoft.com> 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