You'll probably need to use the selectionChange event in the worksheet. I
don't know how to check if M3 was active before the selection change.

You could try something like:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("M3").copy
Range("A1").PasteSpecial
Application.CutCopyMode = False
End Sub

"Einar" wrote:

Hi NG

I've tried to make a Excel VBA macro to take the value from a cell - cell
M3 - when focus is leaving that cell, but I'm not able to do that :-(

Any one in here, who can help me plz