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...

Private Sub Worksheet_Change(ByVal Target As range)

If Target.Value = "Success" Then usrtransfer.Show

End Sub