+ Reply to Thread
Results 1 to 2 of 2

opening macro when the cell value is changed

  1. #1
    Forum Contributor
    Join Date
    12-02-2013
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    112

    opening macro when the cell value is changed

    HI,

    Does anyone knows how to open macro when the cell value is changed in another workbook?

    I have two workbooks and the cell value of FIRST workbook changes when the cell value of SECOND workbook is changed.
    The requirement is to run a macro in FIRST workbook when a new value is entered in SECOND workbook. Thus the cell value should be the value from FIRST workbook.

    Thanks

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: opening macro when the cell value is changed

    This goes in the 1st worksheet module.
    Please Login or Register  to view this content.
    Reference A1 to cell in the other workbook.
    Change the cell in the other sheet

+ 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. [SOLVED] Run macro when cell is changed
    By tjohans in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-12-2014, 03:05 PM
  2. run a macro if a certain cell value changed
    By pubudu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2011, 09:29 AM
  3. Macro for Cell Value over 60 to be changed to 60
    By bmccarthy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2010, 12:58 AM
  4. Run Macro When cell value is Changed
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2008, 08:59 AM
  5. Replies: 1
    Last Post: 03-31-2006, 01:15 PM

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