+ Reply to Thread
Results 1 to 5 of 5

Event to change the value in one cell and viceversa

  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
    Please Login or Register  to view this content.
    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.

  2. #2
    Valued Forum Contributor rollis13's Avatar
    Join Date
    01-26-2012
    Location
    Cordenons
    MS-Off Ver
    Excel 2016 32bit - Win 11
    Posts
    935

    Re: Event to change the value in one cell and viceversa

    A quick solution could be:
    Please Login or Register  to view this content.
    Could also be:
    Please Login or Register  to view this content.
    Last edited by rollis13; 08-14-2021 at 06:27 AM.

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: Event to change the value in one cell and viceversa

    Try this
    Please Login or Register  to view this content.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

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

    Re: Event to change the value in one cell and viceversa

    Ciao Rolando, sono Gerardo, mi fa piacere vederti anche qui in questo forum, ero molto vicino alla soluzione ma mi ero bloccato sul creare un altro evento per creare un altra rutine ma a quanto pare si può creare solo un evento in un foglio

    Rollis is Italian so I translate
    Hi Rollis, I'm Gerardo, I'm glad to see you here in this forum too, I was very close to the solution but I was stuck on creating another event to create another rutine but apparently you can only create one event in a sheet

    Tanks everybody for the answear
    solved

  5. #5
    Valued Forum Contributor rollis13's Avatar
    Join Date
    01-26-2012
    Location
    Cordenons
    MS-Off Ver
    Excel 2016 32bit - Win 11
    Posts
    935

    Re: Event to change the value in one cell and viceversa

    Cecoslovacchia , ecco perchè non ho 'mangiato la foglia' visto il nick.
    Glad we were able to help .

+ 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. 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