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

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

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