Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Target.Value
Hi All, I have a sheet from Excel 2003 which has the code below written in the "view code" in the sheet tab(s) Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'Customize to the cell you want to act as the mirror [B1] = Target.Value End Sub __________________________________________________ _____ I have since obtained a new computer with Excel 2007 installed. It doesn't work in this new version. Am I missing something? thanks for any help you can give me. Tom |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Target.Value
Maybe you didn't enable macros?
Maybe the Target was more than one cell? lehigh46 wrote: Hi All, I have a sheet from Excel 2003 which has the code below written in the "view code" in the sheet tab(s) Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'Customize to the cell you want to act as the mirror [B1] = Target.Value End Sub __________________________________________________ _____ I have since obtained a new computer with Excel 2007 installed. It doesn't work in this new version. Am I missing something? thanks for any help you can give me. Tom -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Target.Value
Thank's Dave. I enabled the macros & that fixed the problem. On Mon, 31 Mar 2008 18:00:16 -0500, Dave Peterson wrote: Maybe you didn't enable macros? Maybe the Target was more than one cell? lehigh46 wrote: Hi All, I have a sheet from Excel 2003 which has the code below written in the "view code" in the sheet tab(s) Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'Customize to the cell you want to act as the mirror [B1] = Target.Value End Sub __________________________________________________ _____ I have since obtained a new computer with Excel 2007 installed. It doesn't work in this new version. Am I missing something? thanks for any help you can give me. Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Target cell reference moves when target is cut and pasted | Excel Discussion (Misc queries) | |||
target.value | Excel Discussion (Misc queries) | |||
Progress to a Target | Charts and Charting in Excel | |||
Go to target cell | Excel Discussion (Misc queries) | |||
Target | Excel Worksheet Functions |