VBA-WorkBook_Change

Cross-posted with responses at https://www.mrexcel.com/board/thread...hange.1189686/

Hello,

I am very new to VBA so this might be a dumb question.

For our company, we have an Excel workbook that has multiple sheets.

We have a Master sheet that all the changes will be made to.

The other sheets are Branches of the master that have linked cells to the master.

I know that there is a way to implement a worksheet_change in order to change the interior color of a cell when it is MANUALLY changed and I know how to implement that.

However, is there a way to implement that same color change across all NON-MANUALLY changed cells within the workbook?

Let me try to give an example so you can better understand what I'm trying to do.

Lets say cell A1 in sheet 1 has the word 'Hello'.

I want cell B2 in sheet 2 to have whatever cell A1 in sheet 1 has... therefore cell B1 in sheet 2 would also have the word 'Hello'.

Now, lets say I want to change cell A1 in sheet 1 to 'Goodbye', I would want cell A1 in sheet 1 to highlight in a light green color. I would then want cell B2 in sheet 2 to say 'Goodbye' (Which it will already do since it is linked to cell A1 in sheet 1) but more importantly, highlight cell b1 in that same light green color.

[VBA]Private Sub Worksheet_Change(ByVal Target As Range)
Target.Interior.Color = RGB(216, 228, 188)
End Sub[/VBA]

This ^^ is what I used to change the color of a cell if it was changed on the master sheet. Which it does work, but just for that sheet.

I just don't know how to tell vba, "Hey, I want you to fill the background of all cells that were changed across the workbook."

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

I have added the link for you since this is your first post.