Target.Value

[lehigh46]

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]

Maybe you didn't enable macros?

Maybe the Target was more than one cell?

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

 

[lehigh46]

Thank's Dave.
I enabled the macros & that fixed the problem.

Maybe you didn't enable macros?

Maybe the Target was more than one cell?

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