Just for reference, if anyone else is interested - declare a module
level variable in the General declarations section to pick up the
value.

You can then access  this value in the change  event to see what the
old and new values are.

One last point to consider, you will get an error if you have this
code and the user  selects more than one cell  so a good idea to trap
for target.cells.count > 1.