Reporting the row means that you would use the Row property of the
selection. To report the value, use the Value property instead.

However, if you are wanting to also pick up changes to the cells  themselves,
you will need to do either of two things ...

1) Handle the worksheet's "Change" event as well. That event will get
fired when the contents of a cell  are changed. Or

2) Instead of putting the value of the source cell into M7, you can put a
formula that links M7 to the active cell. You would do this by assigning
the formula (which is simply a string) to the Formula property of M7. You
can get the address of the source cell (to put in the formula) by looking at
its Address property.