Multiple change events

[MrPez]

--------------------------------------------------------------------------------

I've got a problem with change events...

At the minute I have a worksheet that triggers a macro when the value of a certain cell changes. It works fine, and the code is:

Please Login or Register  to view this content.

My problem is that I am trying to set up the same again that watches another cell and when that value changes it calls a different module. I've tried calling it something like

Please Login or Register  to view this content.

to make it different from the first but it just does nothing. Can you only have one change event per worksheet/workbook? If so, can anyone think of a way around this?

Thanks in advance...
Pez

[DonkeyOte]

You can only have 1 Worksheet_change event per object

Differentiate based on Target...

Please Login or Register  to view this content.

[MrPez]

Thanks! Works a treat.