Unable to use sheet change command

[CHERRYBERRY]

I want to run macro whenever a cell value changes. I have used the code:
private sub worksheet_change(byval target as range)
mymacro
end sub

this code works exactly the way as i change the values manually but this command does not trigger as the cell value automatically changes...... I have tried hard but could not find a solution.
plzzzzzzzz help me. I have to submit my project

 

[Kyle123]

For automatic calculation, it would be easier to use the worksheet_calculate event with specified criteria, worksheet_change as you have found does not fire on auto calc