Excel Cell formulas

[Guest]

How would I make a cell show its results in another cell, without haveing to
enter, any kind of formula into that cell that I wanted the results displayed?

 

[Mauro Gamberini]

Open Excel
Select Sheet1
Alt+F11

Copy:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Sheet1.Range("B1").Value = Sheet1.Range("A1").Value
End Sub

Past on the white sheet.
Alt+F11

Write in A1
Enter