Hi BM,

Right click on work sheet tab , and write down following code in
worksheet selection change event.

Range("D2") = ActiveCell.Value

Regards

Harshawardhan Shastri

================================================== ========


"Showing the content of a cell in another" wrote:

Can anyone tell me, how to do, if I want show the content of a cell in
another cell by clicking on the first cell?

Fx. I click on cell A2, and when I do that it is automatically shown in for
instance cell D2.

Best regards BM.