Anyone on here that is an expert at vba code in excel I need help!!

I need an email sent to a specific address located in a cell, if another cells value changes, but I only want it sent once, I don't want it to keep sending every time the sheet is active.

Which would mean I need the macro to run continuously or on cell change?

Any ideas?