VB Code not applying

[_KerMit_]

Hi,
Hopefully this is a quick easy one, and I'm missing something very simple here!

I have multiple tabs in an excel and in Sheet4 I have VB Code to hide certain rows depending on Value of Cell B3 on Sheet4
The VB Code applies whenever I manually change the Value of Cell B3 on Sheet4, however the problem arises when B3 is changed to reference a Value from another Sheet, the VB Code no longer applies.....
Is there a simple change I could apply to the code (picture attached) to account for this, else is there a Refresh Button I could create which would apply the Code after the Value updated?

Appreciate any help or guidance!

 

[6StringJazzer]

When asking about code it is much better to paste your actual code into the post and mark it as code using the VBA button, rather than posting a picture of your code. Then we can copy, test, and modify your code easily without typing it in from scratch.

Worksheet_Change occurs only when the content of a cell is changed, not when the result of a formula changes. You could try using Worksheet_Calculate, which occurs whenever the worksheet is recalculated. Then you would eliminate the If and End If lines and just do

Select Case [B3].Value

Also, just FYI, your Intersect argument is needlessly self-referential. Instead of Range(Target.Address) you can just use Target.