+ Reply to Thread
Results 1 to 2 of 2

Code to popup a message box after 15 days of the inserted date

  1. #1
    Registered User
    Join Date
    04-10-2012
    Location
    hyderdan
    MS-Off Ver
    Excel 2007
    Posts
    1

    Post Code to popup a message box after 15 days of the inserted date

    Hi Friends,
    i need a code to solve this issue.

    I have 3 columns

    Name date 1st update
    abc 10/04/2012 25/04/2012

    I need a code so that following things can happen.
    1. If i insert the today's date in 'Date' column then automatically '1st Update' column must added 15 days to that date and display.

    2. when i open the sheet on 1st update date then i need a dialogue box to display a Message its time to send 1st update.

    Please help me out

    Thanks & Regards.

  2. #2
    Valued Forum Contributor
    Join Date
    08-29-2011
    Location
    Mississauga, CANADA
    MS-Off Ver
    Excel 2010
    Posts
    503

    Re: Code to popup a message box after 15 days of the inserted date

    Paste this code in the desired sheet code page

    Please Login or Register  to view this content.
    Regards,
    Khaled Elshaer
    www.BIMcentre.com

    Remember To Do the Following....
    1. Thank those who have helped you by clicking the Star below their post.
    2. Mark your post SOLVED if it has been answered satisfactorily:
    • Select Thread Tools (on top of your 1st post)
    • Select Mark this thread as Solved

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1