create a search box in cell

[omairhe]

hello folks..

like in google when i start a search it auto-suggests a word matching wat u typed... can i do this with excel cell S6... the data to look into for the search is column T which starts from T6 to T8605...... hence if T6 is Monday when entering Mo inside S6, it auto suggest 'Monday' ...im using auto filtering in excel 2007 for the mean time ......

thanks in advance

 

[Jaafar Tribak]

I did try doing this HERE but it's ugly and unstable at best and unfortunatly didn't work accross different machines as expected.

I 'am still curious to see if this can be done using a more reliable and cleaner approach.

Regards.

 

[omairhe]

if i want this AWC to function inside cell U3 with Range: U6:U8605. could u kindly make changes in the vba for this to achieve...

Regards
Omair

 

[omairhe]

how about this http://www.contextures.com/xlDataVal10.html

 

[Jaafar Tribak]

how about this http://www.contextures.com/xlDataVal10.html

Thanks omairhe fior the link .

Unfortunately, the solution offered in the link falls short of a true AutoComplete feature that is an autocomplete capability that suggests all the matching words as you type in ( just like Google). It just replicates the poor autocomplete functionality of an activeX Combo box.

Regards.

 

[Jaafar Tribak]

take a look here http://www.mrexcel.com/forum/showthread.php?t=432839

Regards.