Message box on text change value of a certain cell

[PaulCooke]

Hi ,

I am trying to get a Yes/No MsgBox to pop up only when the value of a cell is changed for example is E3 is "London" and it gets changed to "Wales" then a Msgbox would show up.

I am ok with coding the Msgbox itself and dealing with the yes/no responses from it, its just getting it to invoke on the text change bit I'm struggling with !

I've searched about for a solution to this but have had no luck

Could anyone point me in the right direction please ?

Many thanks

[walruseggman]

Take a look at Worksheet_Change.

If you would provide an example of what the Target could be (you mentioned E3, is it only E3 that you want the msgbox for?) Then I could show you an example.

[Kaper]

See sample file.

I used Undo to check previous contents of the cell. When Worksheet_Change event is fired, the cell has already been changed, and we do not have access to it's previous value.

Note that during cell manipulation I switch-off Events (to avoid infinite loop of invoking Worksheet_Change again).

Code in Sheet1 (Arkusz1) is:

Please Login or Register  to view this content.

To see/edit the code, rightclick on sheetname (Arkusz1) tab and select Display code from context menu).

[PaulCooke]

Many thanks Guys for the responses - Kaper's solution works best for what I need although I have adjusted it a bit with regard to the MsgBox to suit my needs.

One question is that if I try to delete the text in E3 it won't let me? any ideas why this is happening?

[PaulCooke]

Just to let you know I have managed to resolve the delete issue - thanks again for all your help !