How to pass a value of a clicked cell to another cell in a different worksheet?

How to pass a value of a clicked cell to another cell in a different worksheet?

• impish

  Hi Guys:

  I work it out. It is very simple. one line of code is enough

  Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  Sheet2.Cells(2, 2) = Sheet1.Cells(Target.Row, Target.Column)
  End Sub

  simply copy the sub to the sheet you want to click and change the receiving sheet number and cell address.

  
  
  

• tall_matt

  Hello Alexander,

  You need to eloborate on what you are trying to do to get a proper response.

  You could try the worksheet_Change event, and then use the properties of the active cell but without knowing what you want to achieve and when to achieve it, it is difficult to answer

  Chas

  
  

• CharissaJB123

  Use this in the module, it will pass the "formula" for clicked cell to sheet2 at A1. Use ActiveCell.Value if you want to value instead. You have to triger this macro by hand. About pass the value to a diffrent cell, just be creative.

  sub PassData()

  Sheets("sheet2").Range("A1").FormulaC1R1 = ActiveCell.FormulaC1R1

  end sub

  
  
• How to pass a value of a clicked cell to another cell in a different worksheet?