+ Reply to Thread
Results 1 to 3 of 3

Autorun macro when cell value is changed

  1. #1
    Forum Contributor
    Join Date
    02-23-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    133

    Autorun macro when cell value is changed

    Hello,

    I have already created a simple code to do Column A - Column C as attached in workbook.
    I want to remove the button, just want to change cell value and when i hit enter,tab or leave the cell with new value, Macro should run and give new results.

    Its difficult to use mouse and keyboard at the same time to click that button every time as there are 100s of rows.
    Is it possible?

    This is the vba code in the attached workbook.

    Please Login or Register  to view this content.
    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Autorun macro when cell value is changed

    Right click on the sheet tab, choose view code and paste this code into the window that pops up. It must be in the sheet code, not in a standard module.

    Please Login or Register  to view this content.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

  3. #3
    Forum Contributor
    Join Date
    02-23-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    133

    Re: Autorun macro when cell value is changed

    Worked perfect. I wanted target.column <> 3 :-) I changed myself.

    Thank you.

+ 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. Macro autorun on cell change
    By hojkoff in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-26-2011, 11:25 AM
  2. Autorun macro when the cell is changed
    By jesseteh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-21-2009, 09:52 PM
  3. Autorun Macro when formula in cell updates
    By ColinNicol17 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-21-2009, 06:21 PM
  4. Autorun AutoFit macro on cell exit?
    By danman1043 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-17-2008, 03:51 PM
  5. When I change a cell a macro will autorun BUT..
    By Infinity in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-31-2006, 12:49 AM

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