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.
This is a discussion on Call Macro on every keystroke within the Excel Questions forums, part of the Question Forums category; I'm creating a "smart" search that will do a search after a user types anything in a cell. So whether ...
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)?
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.
Smitty
Every once in a while, there's a sudden gust of gravity...
Check out my new book at the Mr. Excel Bookstore!
Mr. Excel HTML Maker - Post a shot of your sheet
Got it. Thanks.
Bookmarks