Results 1 to 4 of 4

Call Macro on every keystroke

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 ...

  1. #1
    New Member
    Join Date
    Nov 2008
    Posts
    18

    Default Call Macro on every keystroke

    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)?

  2. #2
    MrExcel MVP
    Moderator
    Smitty's Avatar
    Join Date
    May 2003
    Location
    Crested Butte, CO
    Posts
    27,208

    Default Re: Call Macro on every keystroke

    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

  3. #3
    New Member
    Join Date
    Nov 2008
    Posts
    18

    Default Re: Call Macro on every keystroke

    Got it. Thanks.

  4. #4
    wut
    wut is offline
    Banned
    Join Date
    Dec 2010
    Posts
    229

    Default Re: Call Macro on every keystroke

    Quote Originally Posted by levy8450 View Post
    Got it. Thanks.
    .

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com