Excel Cell formulas

A

adame9176

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?
 
M

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
 
Top