Help with search as you type functionality

[nithinkrishna2005]

HI

I've been trying to use search as you type kind of functionality in one of my excel projects -- i could just find only combobox, which is very difficult to customize and a hassle dealing with huge data set. Is there an alternate which is more fast, and will limit the results to the ones which include only the characters that were typed, similar to the search box and the results box in auto filter.

Thanks,
Nithin.

 

[diddi]

i use such a combobox for loading town names. i wait until user types 3 characters then load select list from full list and display.

eg
make an array called MyList. you may need to index it if you have a large list. mine has about 5000 and works without index at speed.

    Sub Textbox1_Change
        if len(textbox1.value)=3 then
            combobox1.clear
            For myrow=1 to ubound(mylist)
                if textbox1.value=left(mylist(myrow),3) then
                    combobox1.additem mylist(myrow)
                 end if
             Next myrow
             combobox1.visible=true
        End if
    End sub