Hey all! I'm looking for some help on a VBA code that will send an email any time a cell value in range A7:A50 changes to "Expires Soon". I am not well versed in VBA's and could use a helping hand please.
Thank You.
Thank You.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
VBA to email based on cell value in column
Excel Facts
Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Similar threads
- Question
- Question
- Question
