Worksheet.Change process

[Sam173]

Two questions -
I am trying to write a code to run few worksheet changes depending on changes in value of ONLY one cell $A$4. I don't want any other changes in the worksheet to do anything.
So I ran below sample code on a blank worksheet.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$4" Then
Range("$B$4").Value = "changed"
End If
Range("$C$4").Value = "not changed"

End Sub

With this, even when I just click on one of the cells the event is triggered. (i.e. I am not writing anything in the cell, just clicking on it.
My question -

1) Is it then true that the worksheet.change code is running in the background all the time catching any changes but doing nothing? Is that not overhead slowing excel sheet down?
2) Why is it triggering when only clicking on the cell, is there a way to trigger only when something is manually entered in the cell?

 

[Joe4]

Welcome to the Board!

The issue is you are using "Worksheet_SelectionChange", which runs whenever any cell is selected.
You want "Worksheet_Change", which only runs when a cell is updated.

 

[Sam173]

Welcome to the Board!

The issue is you are using "Worksheet_SelectionChange", which runs whenever any cell is selected.
You want "Worksheet_Change", which only runs when a cell is updated.

thank you, appreciate the quick input

 

[Joe4]

You are welcome.
Glad I was able to help!