+ Reply to Thread
Results 1 to 4 of 4

Run a macro when a carriage return is pressed on the cell

  1. #1
    Registered User
    Join Date
    06-17-2013
    Location
    Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    9

    Run a macro when a carriage return is pressed on the cell

    I want to run a macro on the cell, when you press the carriage return key. current code only runs the macro when you copy and paste in the code not when you press "enter". Could someone help guide me in the right direction.

    This is the current code right now

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: Run a macro when a carriage return is pressed on the cell

    Hi
    This code works fine for me. Please advise exactly what error message you are getting.
    Tony

  3. #3
    Registered User
    Join Date
    06-17-2013
    Location
    Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Run a macro when a carriage return is pressed on the cell

    the macro is being called when i copy a cell value from one cell to another but when i just type in a number in the cell, it does not call the macro that it is suppose to run.

    What i'm trying to do is when a data with a carriage return is scanned/typed in, I want it to run the macro to put the necessary information from that data into other columns.

    this is the full code
    Please Login or Register  to view this content.
    the input is a string of about 23 numbers and i'm parsing the needed sections by running the macro

  4. #4
    Registered User
    Join Date
    06-17-2013
    Location
    Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Run a macro when a carriage return is pressed on the cell

    Please Login or Register  to view this content.
    was causing the problem. this should have been set to

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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