user changes sheet1 - have the macro xyz run on sheet3
 

How do I do this?

Whenever the user changes anything on sheet1 to have the macro xyz run on
sheet3.


--

DL

user changes sheet1 - have the macro xyz run on sheet3
 

Tegger,

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

XYZ


End Sub

Put this in the worksheet cod module.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"tegger" wrote in message
...
How do I do this?

Whenever the user changes anything on sheet1 to have the macro xyz run on
sheet3.


--

DL

user changes sheet1 - have the macro xyz run on sheet3
 

Bob,

This won't catch formatting changes or editing in cell (without moving to
next cell). And there are a few other things that won't trigger the event.

The question was "anything" and I don't have an answer to that!

--
sb
"Bob Phillips" wrote in message
...
Tegger,

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

XYZ


End Sub

Put this in the worksheet cod module.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"tegger" wrote in message
...
How do I do this?

Whenever the user changes anything on sheet1 to have the macro xyz run
on
sheet3.


--

DL

user changes sheet1 - have the macro xyz run on sheet3
 

Steve,

I actually meant Worksheet_Change not Worksheet_selectionnChange. I also
never read anything as you did, I read it as any cell. I winder what he
actually means?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"steve" wrote in message
...
Bob,

This won't catch formatting changes or editing in cell (without moving to
next cell). And there are a few other things that won't trigger the
event.

The question was "anything" and I don't have an answer to that!

--
sb
"Bob Phillips" wrote in message
...
Tegger,

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

XYZ


End Sub

Put this in the worksheet cod module.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"tegger" wrote in message
...
How do I do this?

Whenever the user changes anything on sheet1 to have the macro xyz run
on
sheet3.


--

DL

user changes sheet1 - have the macro xyz run on sheet3
 

Bob,

Yep! Happens to us all (especially me).
But following this group is teaching me to watch all the nuances of the
question. And it sounds like he might be looking to track any messing
around along with standard changes. But I could be wrong.

Like you said "I winder what he actually means?"

--
sb
"Bob Phillips" wrote in message
...
Steve,

I actually meant Worksheet_Change not Worksheet_selectionnChange. I also
never read anything as you did, I read it as any cell. I winder what he
actually means?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"steve" wrote in message
...
Bob,

This won't catch formatting changes or editing in cell (without moving
to
next cell). And there are a few other things that won't trigger the
event.

The question was "anything" and I don't have an answer to that!

--
sb
"Bob Phillips" wrote in message
...
Tegger,

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

XYZ


End Sub

Put this in the worksheet cod module.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"tegger" wrote in message
...
How do I do this?

Whenever the user changes anything on sheet1 to have the macro xyz
run
on
sheet3.


--

DL

user changes sheet1 - have the macro xyz run on sheet3
 

That's exactly what I needed thanks.

DL