Speed Search in pick list by typing only first few letters

Is there any facility to pick from the list by typing only first few words (2
or 3) and the curser goes to the matched or nearby entry in the list arranged
alphabetically ? This is similar to locating our topic in the Help index.
In the pick list feature, I have to manually move the curser to the desire
entry. If the list is long, it is not practicable to scroll down the list.
--
Shrikant

A combobox from the control toolbox toolbar has this ability.

Shrikant wrote:
>
> Is there any facility to pick from the list by typing only first few words (2
> or 3) and the curser goes to the matched or nearby entry in the list arranged
> alphabetically ? This is similar to locating our topic in the Help index.
> In the pick list feature, I have to manually move the curser to the desire
> entry. If the list is long, it is not practicable to scroll down the list.
> --
> Shrikant

--

Dave Peterson

Hi Shrikant,
Partial string lookups (#PartialString)
http://www.mvps.org/dmcritchie/excel...#PartialString

See posting
http://groups.google.com/groups?thre...%40tkmsftngp10
the macro FindFirstChar in (finds first characters)
http://www.mvps.org/dmcritchie/excel/code/proper.txt
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Shrikant" <[email protected]> wrote in message news:[email protected]...
> Is there any facility to pick from the list by typing only first few words (2
> or 3) and the curser goes to the matched or nearby entry in the list arranged
> alphabetically ? This is similar to locating our topic in the Help index.
> In the pick list feature, I have to manually move the curser to the desire
> entry. If the list is long, it is not practicable to scroll down the list.
> --
> Shrikant