Passing data to fix cell

[Amnon Wilensky]

Hi,
Is it possible to pass data from any cell on the spreadsheet by clicking on
it, to a predetermined fix cell?

Thanks,

Amnon

 

[Pete_UK]

Have you tried using copy/paste?

Pete

 

[Don Guillett]

How about a DOUBLE click. Right click on the sheet tab>view code>copy/paste
this

Private Sub Worksheet_BeforeDoubleClick _
(ByVal Target As Range, Cancel As Boolean)
Application.EnableEvents = False
With Range("a3")
If Target.Address <> .Address Then .Value = Target
End With
Application.EnableEvents =

 

[HARSHAWARDHAN. S .SHASTRI]

Dear Amnon,

If your predetermined cell is say A1 ,

then right click on sheet tab select view code, in worksheet
,selectionchange event put following code

Range("A1") = ActiveCell.Value

H S Shastri


+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

 

[Amnon Wilensky]

Thanks,

Amnon

"HARSHAWARDHAN. S .SHASTRI"

Dear Amnon,

If your predetermined cell is say A1 ,

then right click on sheet tab select view code, in worksheet
,selectionchange event put following code

Range("A1") = ActiveCell.Value

H S Shastri


+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++