Pop Up Message-VBForums
Results 1 to 5 of 5

Thread: Pop Up Message

  1. #1

    Thread Starter
    New Member
    Join Date
    May 2015
    Posts
    5

    Pop Up Message

    I have an excel sheet that includes a field with name "End Date". I need to run a VB that will check if the current date is the same as the value and send an email. Otherwise to do nothing, can you please help and advise?

    Thanks
    Marinos

  2. #2
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    39,036

    Re: Pop Up Message

    Are you wanting this in the VB Editor inside Excel, or a completely separate VB program?

  3. #3

    Thread Starter
    New Member
    Join Date
    May 2015
    Posts
    5

    Re: Pop Up Message

    I need it inside the excel

  4. #4
    PowerPoster
    Join Date
    Dec 2004
    Posts
    22,636

    Re: Pop Up Message

    what have you tried so far?
    what method do you want to use to send the emails?
    i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
    Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next

    dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part

    come back and mark your original post as resolved if your problem is fixed
    pete

  5. #5
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    39,036

    Re: Pop Up Message

    Thread moved to the 'Office Development/VBA' forum... note that while it certainly isn't made clear, the "VB Editor" in Office programs is actually VBA rather than VB, so the 'VB6' forum is not really apt

Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.