predicitve text

If I have a list of 500 customers in one sheet and I would like to use a
dropdown menu on a seperate sheet is it possible for excel to use perdicitve
text so when I start typing a customers name it lists those customers that
begin with the leters I have typed?
Thanks

Ron

A file that can be downloaded from Debra Dalgleish's site uses a Combobox.

Can be found at

http://www.contextures.on.ca/excelfiles.html#DataVal

Scroll down until you find......

Data Validation Combobox-- Double-click on a cell that contains a data
validation list, and a combobox appears -- font size can be set, more than 8
rows displayed, and autocomplete can be enabled. Macros must be enabled.
DataValCombobox.xls 32 kb


Gord Dibben Excel MVP

On Thu, 3 Mar 2005 21:15:03 -0800, Ron <[email protected]> wrote:

>If I have a list of 500 customers in one sheet and I would like to use a
>dropdown menu on a seperate sheet is it possible for excel to use perdicitve
>text so when I start typing a customers name it lists those customers that
>begin with the leters I have typed?
>Thanks