+ Reply to Thread
Results 1 to 6 of 6

Changing another cell when the cell changes.

  1. #1
    Registered User
    Join Date
    04-29-2022
    Location
    turkey
    MS-Off Ver
    2021
    Posts
    19

    Changing another cell when the cell changes.

    Hello
    When cell B1 changes, the corresponding codes are running
    Likewise, when I change Cell b2, the relevant code does not work.

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, [B1]) Is Nothing Then Exit Sub


    Range("B2") = "TL"
    Range("B3") = "YOK"
    Range("A75") = ""


    If Intersect(Target, [B2]) Is Nothing Then Exit Sub
    Range("B3") = "YOK"



    End Sub
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by deniztopcu; 07-03-2023 at 04:15 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,868

    Re: Changing another cell when the cell changes.

    My eyesight's not that good.

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    04-29-2022
    Location
    turkey
    MS-Off Ver
    2021
    Posts
    19

    Re: Changing another cell when the cell changes.

    Hi
    I have attached the excel file and code.
    Thanks

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,868

    Re: Changing another cell when the cell changes.

    Try it like this:

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    04-29-2022
    Location
    turkey
    MS-Off Ver
    2021
    Posts
    19

    Re: Changing another cell when the cell changes.

    Thank very much...

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,868

    Re: Changing another cell when the cell changes.

    You're welcome.




    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ 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. Adding the cell contents to another cell only by changing colour of cell
    By Chris856 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-17-2021, 03:17 PM
  2. Changing cell colour based on another cell's value, but the latter cell changes
    By Coffee-Hound in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-26-2021, 08:34 AM
  3. Replies: 3
    Last Post: 03-17-2021, 08:19 AM
  4. Auto-move previous content from cell a to cell b by changing cell a
    By Matt81a in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-21-2013, 03:32 PM
  5. [SOLVED] Changing fill color of shapes based on changing cell value
    By Stefan1983 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-25-2012, 10:33 AM
  6. Replies: 5
    Last Post: 08-10-2012, 04:32 PM
  7. Changing cell fill colour based on date in cell - Multiple rows
    By ExcelNewb2010 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-26-2010, 07:30 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