Reading cell value not formula on IF statement

Are you able to upload the workbook?

Would you upload the file to this forum please. Many of us prefer not to visit file hosting sites of unknown provenance

The Sheet change event doesn't react to a change in a formula value, only a change made by the user.

I'm not entirely sure how you operate this workbook but maybe put your sheet change code in the Production QC Form sheet.

i've still been trying to get this to work to avail.

I've dropped the current code, attempted code and copy of a more consolidated workbook. Any pointers would be greatly appreciated.

To Reiterate, I have a set of values that are available via a validated dropdown menu in Sheet 3, Column D. Once selected this value currently displays in a different sheet (Sheet 7) using excel function ='Sheet 3'!D4 and so on, and I have some code that reads this and performs an IF statement to produce a value in another cell.

My problem is the code is dependant on reading the value and not the formula.

I currently have a worksheet change command for a separate function I want to run, is there a way for this to run a second function and call any changes from sheet 3 column D into sheet 8 column D and then run my other change function?

Sheet 7 Code:

Please Login or Register  to view this content.

Sheet 7 Module:

Please Login or Register  to view this content.

I've been trying this route but to no avail:

Worksheet 3 code:

Please Login or Register  to view this content.

Module:

Please Login or Register  to view this content.