Worksheet Change event not updating when data is copied

Hi experts,

Is it possible to have a worksheet change event updated if data is copied from one cell to another. It updates if the data is manually amended/entered, but I suspect some users will copy and paste into the cell, in which case the code is not working for that.

I'm not sure how to post the code in here (as I think it has to be a certain way). Last time, I violated the requirements by posting code in the forum. Can someone assist how I can post the code and I'll do that so the code can be looked at (if it is possible to update information on another sheet using a change event when data is copied rather than manually entered).

Thankyou heaps:-)

Hi, notemore. Yes, worksheet change event does work when data is copied and pasted. Here's a simple code for testing purpose. Check if the message box appears when you copy data and paste into the other cell.

Please Login or Register  to view this content.

When you post the code, just wrap the code with [CODE] tags.
Please refer to forum rule #3.

HI

Thankyou as I was not sure how to go about it. this code is from the expert Sktneer and it does exactly what I want except when data is copied or pasted. A user must enter in the cell manually and press enter for it to work. I need the flexibility to allow copying and updating with multiple cells as well . A user might copy info from one cell and paste it in 3 cells in the same row or another row.

Please Login or Register  to view this content.

What should be amended in this code to allow copying and pasting info on multiple cells to occur and be updated to another sheet.

Many thanks.

Yes, the code is using the same worksheet change event and it doesn't update if copied, it only triggers when enter is pressed

I tried that line, and commenting it out and the same thing happens.

No copy paste for a single cell doesn't work either.

It says: For sheet (both worksheet and chart sheet) level events, the event procedure code must be placed in the Sheet module associated with that sheet.

It is placed at the worksheet (in the sheet module) associated with that sheet. But it copies to another page, perhaps that is where the issue is?

xlnitwit

sorry, I overlooked and missed your post with the updated code. It works a treat... awesome - thankyou.

oh goodness, where is the solved button?

Thank you, I found it and marked it as solved. But I can't tell whether the credit/acknowledgment went to you? Am I missing something, do I need to do anything else?