How to Automatically Clear Cell in Excel When Another Cell Changes

Subscribe to my channel and unlock exclusive benefits!

In this tutorial, we delve into a unique Excel functionality that isn't available by default. Learn how to automatically clear the value of a specific cell (e.g., C7) when another cell (e.g., C6) changes its value. This technique requires a bit of VBA coding.
_______________________
VBA Code mentioned in the video:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("C6")) Is Nothing Then
Range("C7").ClearContents
End If
End Sub
_______________________

🎓 What You'll Learn:

• Understand the default behavior of Excel cells.
• Access the VBA editor and apply the provided code.
• Customize the code for different cells.
• Save your file as a macro-enabled workbook.

📌 Key Takeaways:

• Excel's default behavior doesn't auto-clear cells based on changes in other cells.
• With a simple VBA code tweak, you can achieve this functionality.
• Always save your modified Excel file as a macro-enabled workbook to ensure the VBA code runs correctly.

Timecodes:
0:00 Introduction
0:09 Default behavior of Excel cells
0:34 The VBA code effect
0:56 Inputting the VBA code
2:54 Save as a macro-enabled workbook

[ASVExcel]

Timecodes:
0:00 Introduction
0:09 Default behavior of Excel cells
0:34 The VBA code effect
0:56 Inputting the VBA code
2:54 Save as a macro-enabled workbook

[MVWMGMT]

Thanks for the vid! If others are wondering, I wanted to clear multiple cells from a single change. To do this, just include the additional cells in the code like this:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("C6")) Is Nothing Then
Range("C7, D7, E7").ClearContents
End If
End Sub

[YSUWarehouse]

Worked 100%. Super fast and simple solution after a long time searching the internet. Thank you

[DS-usnb]

Brilliant video, perfectly clear instructions, Really helped me out, thank you.

[EinSophistry]

Is there a way to make this code activate for changes that result from a formula or sort? For some reason, I can only get it to work in such cases if I copy the changed cell's contents and paste them back in the same place.

[jconks]

Excellent video. But what if I press either the delete key or the backspace key in cell C6, can I clear the contents of the other cell this way?

[ajitjoshi]

Nice explanation. I wanted this code. When I copied this code and changed the cell, Nothing is happening. Can you please help in resolving this.

[madalinradu]

Hi, what if i would need the same thing on a different area of the spredshed, how do i modify the code?

[shrimp]

Does this work if the change happens due to automatic date change

[dizangoh]

It works, however UnDo doesn't work in case if I need to revert back...