excel problem - list box

[sarah]

Hi - when validating a cell to a list box how do I set the list box so
that when inputting the first or first few letters the list it
automatically goes to the items in the list beginning with these or
this letter???

At the moment I've got a list of around 100 items and having to scroll
all the way through is a nightmare

Any help would be greatly appreciated.

Thanks

 

[Frank Kabel]

Hi
this is not possible with this type of listbox. So no
solution for it