Call Macro on every keystroke

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Call Macro on every keystroke

  1. #1
    New Member
    Join Date
    Nov 2008
    Location
    SF Bay Area
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Redmond, WA
    Posts
    29,498
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    2 Thread(s)

    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.

  3. #3
    New Member
    Join Date
    Nov 2008
    Location
    SF Bay Area
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Call Macro on every keystroke

    Got it. Thanks.

  4. #4
    Banned
    Join Date
    Dec 2010
    Posts
    229
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Call Macro on every keystroke

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

User Tag List

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