Sam,
How does the 5 get into the priority field? Is it typed in by a user or
calculated by some formula in the cell(s). I also presume this could be in a
list in a particular column? What column?

I ask those questions because if the value is typed in by someone, then you
can use the Worksheet_Change() event to test for an entry of 5 in the
cell/column and send the email based on that. But if it's controlled by a
formula, then things get more difficult in an unattended workbook.

"sam" wrote:

How can I send an email if the value of a certain field changes to something.

For eg: If Priority field changes to 5 I want to send an email to myself.

I know how to get the email working on click of a button on the userform,
But dont know how to get it working once a field is updated.

Thanks in advance.