I thought I had this one though fell at the final hurdle.

When certain values are pasted into a column I want a message box to pop up.

I have managed to achieve this with the code below in the worksheet code. Though this only works where I paste only that value into the column.

However the data is being copied from another spreadsheet as part of a range of cells.

When a range of cells is pasted into the spreadsheet the macro isn't triggered.

Any suggestions to improve this so that msg box appears when this value is identified.

And now to be greedy in case anyone knows if this is possible. If the message box can contain a Yes / No option with Yes triggering another macro? I'm thinking this is too much for worksheet code. Not necesary though would be nice.

Thanks all

Please Login or Register  to view this content.