Results 1 to 4 of 4

Cannot link two cells between worksheets

Threaded View

dimattia Cannot link two cells between... 05-17-2013, 10:55 AM
ragulduy Re: Cannot link two cells... 05-17-2013, 11:16 AM
tehneXus Re: Cannot link two cells... 05-17-2013, 11:21 AM
dimattia Re: Cannot link two cells... 05-17-2013, 11:36 AM
  1. #1
    Registered User
    Join Date
    05-13-2013
    Location
    edmonton alberta
    MS-Off Ver
    Excel 2010
    Posts
    7

    Cannot link two cells between worksheets

    Hey, I'm new here and to vba so any help is greatly appreciated!

    I want to be able to "link" two cells together so if you enter a value into one cell the other cell will match it, and vice versa. I can do this with two cells in the same worksheet, but I cannot figure it out if they are on different worksheets.

    Here is the code I am using, and its in the "ThisWorkbook" section in "Microsoft Excel Objects" folder when you open vba.

    Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    
    
    If Target.Address  = Worksheets("LC1").Cells(1, 1) Then
    
        Worksheets("LC2").Cells(1, 1) = Worksheets("LC1").Cells(1, 1)
    
    End If
    
    
    If Target.Address = Worksheets("LC2").Cells(1, 1) Then
    
        Worksheets("LC1").Cells(1, 1) = Worksheets("LC2").Cells(1, 1)
    
    End If
    
    
    End Sub
    I have tried several combos such as changing "Target.address (0, 0)" and nothing seems to work
    Thank you in advance!
    Last edited by dimattia; 05-17-2013 at 11:34 AM.

Thread Information

Users Browsing this Thread

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

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