Change Event - Set specific range for target question

Can I set a specific range for target instead of every cell in an active worksheet?

Let's say I would like to show a userform whenever Column(5) has a value of "Success". If another cell outside Column(5) has that value nothing should appear.
How would my code look like?

This is what I got so far...

Please Login or Register  to view this content.

I think you should use intersect.

Please Login or Register  to view this content.

Thank you very much!