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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How Would I code A1= A2 (When selected).A3 (When selected) in Excel
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

About Data Validation 2
Help Creating Excel Formula 4
how to use if formula in list (data validation list) 1
Avoiding redundant calculations 7
Unable to obtain relative reference using conditional formatting 2
Two functions in one formula. 1
Can conditional formatting be used where ..... 2
I have a pairs of numbers 1

Back
Top