Passing data to fix cell
 

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

Thanks,

Amnon

Passing data to fix cell
 

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

Passing data to fix cell
 

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

Passing data to fix cell
 

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

Passing data to fix cell
 

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