Worksheet event to run macro when cell changes

[Keibri]

Hi All,

I would like to aks whether someone can help me with the below.

I m trying ot have a worksheet event trigger when a certain value changes. So if the value in cell D5 changes, a worksheet event calls a macro.

For a strange reason the macro is not being called when the value changes.

Can someone please help me out.

Appreciate a lot your help!

For ease of reference I have attached the file.

Please Login or Register  to view this content.

Thanks


Keibri

[sktneer]

Replace the following line

Please Login or Register  to view this content.

WITH

Please Login or Register  to view this content.

[Keibri]

Oh brilliant! Thanks a lot man! never thought it was affecting the whole trigger !

[sktneer]

You're welcome Keibri!
Don't worry, it happens with all of us when we ignore the most obvious silly mistakes.