Running code when cell contents change

I have some code which at the moment I run from a button which copies the contents of certain cell to a different location.

I would like to run this code when the contents of a particular cell change but I also have another three cells and depending on which cell changes a slightly different version of the code needs to be run.

Hello Mark,

You can test for one or more cells anytime the user selects a cell on the worksheet by placing you code in the Worksheet_SelectionChange procedure for the worksheet you are checking.

To Test If a certain cell was Selected:
________________________________________________________________

'Cell of interest = $H$30

If Target.Range.Address = "$H$30" Then

...your code routine

End If
________________________________________________________________

Hope this helps,
Leith Ross