To inlcude search functionality in List box.

Please help me with this problem. By typing either first letter or first two letters in cell A2 the list box should bring up matching street names. Also listbox should mannualy allow to select required street name by scrolling down. I cant find a way to work this out any help will be really great.

Please check the file, Im suggest drop down list with long list I think thats not efficient, maybe this is meet your need

Regards
Azumi

Thank you for quick solution. But I prefer a list box search. Please revise if you could.

If you insist with list box search, maybe you need VBA Expert to do that, I guess better if you movin to

http://www.excelforum.com/excel-programming-vba-macros/

Regards

Azumi