On Mar 26, 2:48 pm, "kaiser" wrote:
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....

Just for further clarity - I have written a macro that does the above
when the cell value has changed, but I want to ahve the search
function run as EACH BUTTON IS PRESSED and not when enter is pressed
(ie, when the cell value is changed)