I have a code that I can attach to a button in excel so that when clicked - it automatically sends an email of my choosing to whom I declare it to... HOWEVER.. that is fine when attached the macro to a button.
BUT, what I now need to do is to apply this code (or similar) to a change in a specific cell?
my problem is i cant for the life of me figure out how to do that in vba. i just don't know the commands to do that.
all i need is an example of someone using an If/else statement referring to a specific cell on the spreadsheet - (e.g. if c4 = something, send the email)
thanks.
and i can do the rest
Bookmarks