How to Trigger Worksheet_Change event in a different worksheet

PoggiPJ

Active Member
Joined
Mar 25, 2008
Messages
330
Is there a way from my active worksheet, to simulate a user entry and calculation on another (inactive) worksheet that exists within the same workbook?

Application: I want to remotely change values on detail sheets from my summary sheet and see the immediate financial effect of those changes rolled up on my summary totals.

I hope I'm explaining this clearly
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
Can you give more detail? Your change event can be used to change cells on lther sheets, but I'm not sure that's what you mean.

lenze
 

PoggiPJ

Active Member
Joined
Mar 25, 2008
Messages
330
Sure Lenze

Yes, I know I can change the value in another sheet. That is the first step. I'll outline the steps.

1. Change a discount entry in summary sheet
2. Within the summary, determine which (inactive) detail worksheet discount needs to change.
3. Change the discount value in the inactive worksheet. I'm fine up to here.
-This is where I need the help -
4. Within the remote worksheet, make the Worksheet_change macro run (just as if the user had made the change within that detail sheet) that applies the updated discount to all of the line items in this sheet.


Does this help at all?
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,122,564
Messages
5,596,863
Members
414,106
Latest member
Tigretto

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top