Call Macro on every keystroke

[levy8450]

I'm creating a "smart" search that will do a search after a user types anything in a cell. So whether it's two or three characters or several more, I want to call a macro. The outcome would be similar to the Google search page.
Any ideas how to call a macros based on a user typing in a given cell (without the user having to press return or leave the cell)?

 

[Smitty]

Not gonna happen (natively anyway). Excel is on hold while you're in edit mode and nothing's going to happen until you exit.

You might be able to use a User Form text box and its Change event.

 

[levy8450]

Got it. Thanks.

 

[wut]

Got it. Thanks.

.