From a Data Range > DoubleClick on a cell to populate elsewhere

  • Thread starter Thread starter KalliKay
  • Start date Start date
K

KalliKay

I have a large named data range that when one cell is double clicked on that
I would like the value from that cell to populate in a cell on another
worksheet. Is that possible? Thx.

KK
 
Put the following event macro in the worksheet code area:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Target.Copy Sheets("Sheet2").Range("A1")
Cancel = True
End Sub

It will take any cell double-clicked and copy the contents to Sheet2 cell A1.

Adjust to suit.
 
Back
Top