Private Sub Worksheet_SelectionChange() doesn't run

[filipovbf]

Hallo!
I have the problem with running the code shown below.
This code is written in Sheet2.
The cell range "MyRange" is in Sheet2, and the macro "MyMAcro" is in module1 of VBA.
When I change any cell value in "MyRange" the code doesn't run.
Any Help?
Thanks in advance!
Bobby

 

[Peter_SSs]

When I change any cell value in "MyRange" the code doesn't run.

If you want it to run when you change a cell in MyRange then you want
Private Sub Worksheet_Change(ByVal Target As Range)
not
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

 

[filipovbf]

If you want it to run when you change a cell in MyRange then you want
Private Sub Worksheet_Change(ByVal Target As Range)
not
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Thank you Peter! I changed with "Private Sub Worksheet_Change(ByVal Target As Range)", but nothing happends.

 

[Peter_SSs]

Are you changing values in MyRange manually or are the changes the results of formulas?

 

[uk747]

At some point enable events maybe false, maybe your code turned it off and didn't turn back on if

Goto immediate window and type
?application.enableevents

 

[Fluff]

The cell range "MyRange" is in Sheet2, and the macro "MyMAcro" is in module1 of VBA.

The code needs to go in the sheet module, not a standard module.

 

[filipovbf]

Are you changing values in MyRange manually or are the changes the results of formulas?

Thanks of all who wanted to help me, but it seems the problem have been very simple. After I changed
"Private Sub Worksheet_SelectionChange(ByVal Target As Range)"
with
"Private Sub Worksheet_Change(ByVal Target As Range):
and nothing happened, I just restarted Excel and my code start to work.
Thanks one time more!!

 

[Alex Blakenburg]

Thanks of all who wanted to help me, but it seems the problem have been very simple. After I changed
"Private Sub Worksheet_SelectionChange(ByVal Target As Range)"
with
"Private Sub Worksheet_Change(ByVal Target As Range):
and nothing happened, I just restarted Excel and my code start to work.
Thanks one time more!!

That tends to support @uk747's line of thinking.
The suggestion there was to see if EnableEvents was turned on or off in the immediate window by entering.
(the question mark is the equivalent to "print to the immediate window")

? Application.EnableEvents

After the code crashes it is often the case that settings turned off don't get turned back on again.
You could go straight to trying to turning it back on with the below in the immediate window.

Application.EnableEvents = True

Reopening the workbook also resets these settings

If you don't have the immediate window visible Ctrl+G while in the VBA window will make it visible.