Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
user changes sheet1 - have the macro xyz run on sheet3
That's exactly what I needed thanks.
DL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What to do to run macro on sheet1 to sheet10 | Excel Discussion (Misc queries) | |||
Using Macro, want to group all Worksheets, but Sheet1,How? | Excel Discussion (Misc queries) | |||
Macro-Copy various cells in sheet1 into next available row in sheet 2 | Excel Discussion (Misc queries) | |||
Modifying Sheet1 macro to run on Sheet2 | Excel Discussion (Misc queries) | |||
consoildate all the worksheet(example sheet1,sheet2 and sheet3 etc | Excel Worksheet Functions |