+ Reply to Thread
Results 1 to 4 of 4

Activate macro while pressing ENTER Key

  1. #1
    Registered User
    Join Date
    03-13-2016
    Location
    casablanca
    MS-Off Ver
    2013
    Posts
    6

    Activate macro while pressing ENTER Key

    Hello everybody,

    i got some help from Mr lone_wolf on creating an excel file that lunch a sound while a value is true.
    no what i need is to activate that code while enter key is pressed,
    please fond below the used code, your help is much appreciated
    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    09-23-2007
    Location
    Melbourne, Australia
    Posts
    176

    Re: Activate macro while pressing ENTER Key

    Just by pressing the 'Enter' key? Or by pressing the 'Enter' key and something else?

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,819

    Re: Activate macro while pressing ENTER Key

    Perhaps you are looking for the change event instead of or in addition to the selectionchange event.

    List of events associated with the worksheet object https://msdn.microsoft.com/en-us/lib.../ff841127.aspx
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #4
    Registered User
    Join Date
    03-13-2016
    Location
    casablanca
    MS-Off Ver
    2013
    Posts
    6

    Re: Activate macro while pressing ENTER Key

    Hello,

    Thank you for your replies, attached you find the file without .WAV files.
    As u can see, the code get activated when you click on the tracking.

    what I need is to execute the code after pasting the code and pressing ENTER, not necessary an enter key ( on the keyboard ), be cause I copy the trackings using a barcode reader, and that barcode past automatically the tracking and it clicks on enter automatically, it goes to the below cell (ex : past on A2, and go automatically to A3 to past another tracking )

    Sorry I'm facing problems attaching the file,
    please find the link to download it : search-code.zip

    Sorry for my bad English

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. No Cell Movement after Pressing Enter with this macro I'm using on a protected sheet
    By Janet_824 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-25-2016, 02:59 PM
  2. Replies: 1
    Last Post: 12-12-2012, 08:46 PM
  3. [SOLVED] activate sort macro on enter
    By FDibbins in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-10-2012, 04:54 PM
  4. Trigger macro when entering text in a cell, without pressing enter
    By DGagnon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-06-2012, 05:53 PM
  5. How To Activate Macro when ENTER key not touched when entry made
    By Launchnet in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2010, 11:42 AM
  6. Run Macro by Pressing Enter Key
    By styre in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-02-2009, 03:49 PM
  7. execute macro after pressing enter
    By ledzepe in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-03-2008, 05:44 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1