VBA Formula to have excel send out an email message once a certain cell reaches below a certain quantity

[tazimmer]

Hi,
Just looking for some help as I have limited knowledge when it comes to VBA. What I'm trying to do is have an email send out to two individuals once a certain cell reaches below a certain number. The excel spread sheet tracks our stock quantities of a particular item and we want to be notified once the stock levels sink below 600 pieces. I don't know where to start when it comes to drafting up a VBA formula. I did a bit of work with VBA in college but it has been years since I have used VBA. If someone could help me out, I would greatly appreciate it.

 

[Logit]

Sent you a private message.

 

[Logit]

Not certain you received my last private message. The Forum is telling me some junk about your mail box being full and won't accept any more messages.
Faulty error message !

Yes, forward the file to my personal email address I sent you.

Thanks.

 

[tazimmer]

I never got a pm from you, because it said my inbox was full...it only allows me 1 message which I think is kinda dumb. So I have to delete every message I receive or send in order to send or receive a new message.

 

[tazimmer]

Just shoot me an email at: talon.zimmerman@agropur.com
Thanks