Hi Louise,

Debra Dalgleish shows how you can get autocompletion to work in data
validation using a combobox - see this link:

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

Hope this helps.

Pete

On Jan 8, 2:01*pm, Louise wrote:
Hi all

I have used the above function to create a drop-down list in a range of
cells in Excel. *Is there any way that, when you click onto the drop-down
arrow, you can quickly get to, for example, items beginning with the letter
's' in the list? *I've tried simply pressing the key and it doesn't work.

Is there such a function?

THank you.
Louise