M
Mike H
Hi,
You can capture these values using the worksheet change event. Right click
the sheet tab, view code and paste this in:
Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox Target.Value & Chr(13) & Target.Address & Chr(13) & Target.Column &
Chr(13) & Target.Row
End Sub
change a cell and a message pops up with the value, address, row and column
Mike
You can capture these values using the worksheet change event. Right click
the sheet tab, view code and paste this in:
Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox Target.Value & Chr(13) & Target.Address & Chr(13) & Target.Column &
Chr(13) & Target.Row
End Sub
change a cell and a message pops up with the value, address, row and column
Mike