Results 1 to 5 of 5

Event to change the value in one cell and viceversa

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-15-2015
    Location
    Cecoslovacchia
    MS-Off Ver
    365 personal
    Posts
    100

    Event to change the value in one cell and viceversa

    Hello VBA friends
    I'm learning VBA
    I made this code that works fine, this code change the value in column A if there is a change in column C
    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim i As Integer
    If Not Intersect(Target, Range("C1:C5")) Is Nothing Then
            For i = 1 To 5
                    Cells(i, 1).Value = Cells(i, 3).Value
            Next i
    End If
    
    End Sub
    but now i need to do vicevirce i mean i need also to change the value in column C if there is a change in column A
    I was going to do onother event but is not possible
    see attachmant
    Thank you for your help
    Attached Files Attached Files
    Last edited by GerryZucca; 08-14-2021 at 07:20 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Worksheet change event with multiple column cell value change
    By borgyang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-29-2015, 11:53 AM
  2. help with afind replace and change of data amount from minus to postive and viceversa
    By leanne2011 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-20-2011, 11:48 AM
  3. Worksheet Change event ignore change event
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2011, 12:29 PM
  4. Change Event doesn't change until I return to the Target Cell
    By carsto in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-11-2007, 05:20 PM
  5. Cell value change to trigger macro (worksheet change event?)
    By Neil Goldwasser in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-10-2006, 10:00 AM
  6. [SOLVED] Worksheet Change Event-change event to trigger
    By Steph in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-18-2005, 06:05 PM

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