+ Reply to Thread
Results 1 to 6 of 6

Request for help in visual basic to create automatic popups when reaching expiry date

  1. #1
    Registered User
    Join Date
    06-03-2012
    Location
    Dubai, UAE
    MS-Off Ver
    Excel 2010
    Posts
    3

    Request for help in visual basic to create automatic popups when reaching expiry date

    Hey guys!

    Hope all of you are doing well! I just joined this forum yesterday and Im a complete beginner when it comes to programming. Right now I've been trying to come up with a code/software whereby automatic popups can appear when the applicant's visa date expires. My supervisor told me this could be done using Visual Basic at Excel. I've been trying to read tutorials and watch videos on Youtube but I'm completely lost!

    It would be great if you guys could help me out of this. I'm attaching a sample Excel file with what I've been working.

    Thanks alot!

    Cheers!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Request for help in visual basic to create automatic popups when reaching expiry date

    Hi

    Try this code:

    Sample Excel File.xlsm
    Click *, if my suggestion helps you. Have a good day!!

  3. #3
    Registered User
    Join Date
    06-03-2012
    Location
    Dubai, UAE
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Request for help in visual basic to create automatic popups when reaching expiry date

    Hey jraj! Thanks alot. But I have no idea what you just did. I have edited the sample excel file with one of the expiry dates changed to todays date. Do you know how to make a code whereby a popup of "Visa has expired" will appear on that cell, and on the other cells in the future?

    Thanks alot!

    Akriti
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Request for help in visual basic to create automatic popups when reaching expiry date

    You want to check individual rows for visa expiry... Is that the way you want it to work?

  5. #5
    Registered User
    Join Date
    06-03-2012
    Location
    Dubai, UAE
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Request for help in visual basic to create automatic popups when reaching expiry date

    Yes individual rows...

    Thank you.

  6. #6
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Request for help in visual basic to create automatic popups when reaching expiry date

    Now just check this out:

    Sample Excel File.xlsm

+ 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