A1= A2 (When selected).A3 (When selected)

  • Thread starter Thread starter Guest
  • Start date Start date
Maybe:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
[A1] = ActiveCell.Value
End Sub

Go to the VBA Editor (Alt+F11), click on the sheet where need this code and
paste above code into the code window.
It will put the value of the Active cell (=same as seleted cell if only one
cell is selected) into A1.

Cheers,

Joerg
 
Thats exacly what I needed. Thanks alot.

Joerg said:
Maybe:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
[A1] = ActiveCell.Value
End Sub

Go to the VBA Editor (Alt+F11), click on the sheet where need this code and
paste above code into the code window.
It will put the value of the Active cell (=same as seleted cell if only one
cell is selected) into A1.

Cheers,

Joerg








electromatt said:
How Would I code A1= A2 (When selected).A3 (When selected) in Excel
Click to expand...
Click to expand...
 
Back
Top