Hello,

I hope that someone can help me. I am trying to create a search
function that searches through a single column on the following
manner.

Column A:

Beach Boys
Beatles
Dire Straits



When the user enters (into either a cell or a form, cell probably
easiest) a letter the macro must search for words starting with that
letter, when the user enters another letter the search must refine
that list.

For example:

If the user enters "b"

Beach Boys
Beatles

will be displayed.

When the user enters "beat"

Then only Beatles will be displayed. Expect the macro must happen
without the user pressing a button, ie, just when the user enters the
search string/letter into a cell then the search function must kick
in.

You know iTunes? Well, pretty much like the iTunes search function.

Thanks....