PDA

View Full Version : Help writing a VBA code!!!



PastorJDRH
01-21-2011, 11:33 AM
Hello All,

I am having the most difficult time writing a VBA code that prompts either a message box or an email to pop up on a certain date.

Here's the deal. I have an Excel Spreadsheet with a list of dates. On a particular date, with the workbook open, I want excel to either pop a msgbox up that says "Smart Bros. Corp. Time for Cert Renewal" or open an email through outlook.

I appreciate any and all help. I am a beginner in VBA so please explain it simply.

Thanks!

xld
01-22-2011, 03:57 AM
How would it know which date amnd where would it get the data to display?