Consulting

Results 1 to 2 of 2

Thread: Help writing a VBA code!!!

  1. #1

    Question Help writing a VBA code!!!

    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!

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    How would it know which date amnd where would it get the data to display?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •