| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
From a Data Range DoubleClick on a cell to populate elsewhere
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
From a Data Range DoubleClick on a cell to populate elsewhere
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. -- Gary''s Student - gsnu200851 "KalliKay" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populate worksheet with data that meets date range criteria | Excel Worksheet Functions | |||
| Populate cell range | Excel Worksheet Functions | |||
| doubleclick in cell to open link - how | Excel Worksheet Functions | |||
| QUERY data range to populate separate worksheet? | Excel Worksheet Functions | |||
| Force VB to doubleclick in a cell | Excel Discussion (Misc queries) | |||
Linear Mode
