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

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

ChasAA at 2007-8-31 >

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.

ChrisHou at 2007-8-31 >