Unable to use sheet change command

Status
Not open for further replies.

CHERRYBERRY

New Member
Joined
May 31, 2012
Messages
29
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
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
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
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,211,741
Messages
6,103,647
Members
447,875
Latest member
kaku_1728

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top