Passing data to fix cell

  • Thread starter Thread starter Amnon Wilensky
  • Start date Start date
A

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
 
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 =
 
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


+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 
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


+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Click to expand...
 
Back
Top