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

Thanks,

Amnon

Have you tried using copy/paste?

Pete

On Mar 9, 10:29*am, "Amnon Wilensky" wrote:
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 tabview codecopy/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 =

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Amnon Wilensky" wrote in message
...
Hi,
Is it possible to pass data from any cell on the spreadsheet by clicking
on it, to a predetermined fix cell?

Thanks,

Amnon

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" wrote:

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

Thanks,

Amnon

Thanks,

Amnon

"HARSHAWARDHAN. S .SHASTRI"
wrote in message
...
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" wrote:

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

Thanks,

Amnon