vba to reflect change in all sheets

[dcheulkar]

Hello all,

I am new forum and VBA too. I have an excel file with 40 sheets. What I am looking for is Whatever I will write in cells A4 of sheet1. It should reflect in all remaining sheets of the workbook in cells A4, C11 and F9.


Looking for help.


Thanks

[YasserKhalil]

Hello and welcome to the forum
Try this code in the module of sheet1

Please Login or Register  to view this content.

[leelnich]

Hi dcheulkar, welcome to the forum. Try this:

Please Login or Register  to view this content.

In Excel, right-click on the Sheet 1 Tab and select View code. Paste the above code in the window that appears. Then press ALT+F11 to return to Excel.

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

[Richard Buttrey]

Hi,

Another option

Please Login or Register  to view this content.

Any change made in ANY sheet will be reflected in all.

If you wanted to exclude a particular sheet from the group then add a condition. e.g.

Please Login or Register  to view this content.

[dcheulkar]

Thanks you very much for your reply.

How does this code works. Actually, I have a small macro written for some other process in my report. I want to include your code in my exisiting macro. Will it work.
Can you please guide me.

Thanks

[leelnich]

To which code are you referring? Posts #2,#3 are essentially identical event procedures which reside in the worksheet module and respond automatically to changes in A4. Post #4 code is incomplete- Richard was demonstrating a different way to access the worksheets, but code must be added to actually update the cells.
Perhaps you could post YOUR macro so we can determine how to proceed.

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee