+ Reply to Thread
Results 1 to 2 of 2

Quad-linking cells VBA code

  1. #1
    Registered User
    Join Date
    08-18-2015
    Location
    UK
    MS-Off Ver
    2010
    Posts
    1

    Quad-linking cells VBA code

    Hi there,

    I am working on a piece of code to be able to quad-link cells (any change of any of the cells will be reflected in all the others, no matter where the change was made). To make it easier to use for those in the office who are not that comfortable in VBA, I used a skeleton format I found online that utilises cells in a separate worksheet (called 'Mapping'), where the first row is declaring sheet names and all cells below are representing the cells I want to link.

    However, despite the code running (and desperately going through line by line for a fix) it is not working as intended- it appears only the first worksheet cells seem to be copied onto others. If anyone has any idea on what I have programmed incorrectly and any fix I would be massively appreciated.

    My code:

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,945

    Re: Quad-linking cells VBA code

    Your code worked for me, but this also seems to work for me, and the code is a bit tighter.... I think you may have disabled events by mistake.


    Please Login or Register  to view this content.
    Last edited by Bernie Deitrick; 09-02-2015 at 01:04 PM.
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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. Linking a Number Code to a Name
    By krutherford in forum Excel General
    Replies: 10
    Last Post: 08-04-2015, 05:14 AM
  2. [SOLVED] Linking cells globally to allow users the ability to change cells on separate sheet/cells.
    By V1gilante in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-18-2014, 10:47 PM
  3. VB code for Linking combo box's
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2014, 02:07 PM
  4. [SOLVED] Linking 2 pieces of vba code
    By michelle 1 in forum Excel Programming / VBA / Macros
    Replies: 54
    Last Post: 07-19-2013, 08:10 AM
  5. Replies: 1
    Last Post: 10-03-2012, 12:17 PM
  6. Linking cells to permutation code
    By shiqs28 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-19-2012, 10:44 AM
  7. linking VB form to VB code
    By shadowchaos5k in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-11-2012, 06:15 AM
  8. Linking code to a cell
    By Fernandoalberte in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-30-2005, 08:05 AM

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