Show Userform when cell value changes code not working

[drluke]

In my worksheet I have a drop down list in D4 and in E4 I have a XLOOKUP formula with the lookup value being the value in D4. I want a user form to show when the value in E4 changes, however I cannot get my code to work for me.

Private Sub Worksheet_Change(ByVal Target As Range)

    If Not Intersect(Target, Range("E4")) Is Nothing Then
        Load frmActions
            frmActions.Show
                End If
    End Sub

Any advice would be appreciated.

 

[Anthony47]

The Change event is triggered when a change is done by the user, not by a formula.
I understand that E4 depends on D4; so it should be sufficient modify your Range("E4") to Range("D4") and it should work

Bye

 

[drluke]

The Change event is triggered when a change is done by the user, not by a formula.
I understand that E4 depends on D4; so it should be sufficient modify your Range("E4") to Range("D4") and it should work

Bye

Thank you Anthony. That did do it.

 

[Anthony47]

Thank you for the feedback