/vba_date_compare

Simple date comparison and reminder script/macro for Microsoft Excel files.

Primary LanguageVisual Basic .NET

Lexxeous's VBA Date Compare:

Summary:

Simple Visual Basic for Applications project. The VBScipt will be a macro attached to a Microsoft Excel document. Upon opening the .xlsm file, there is a single reminder event attached and the public at_time() procedure is called. The at_time() procedure is also recursive and calls itself to persist the attached reminder event as long as the file is open. A loop is used to look through the first 1000 rows of two different sheets. The script then compares today's date (and today's date plus 3 days) with the date values provided in the Excel sheets. When there is a match, a message box pop up is generated to inform the user about the reminder.

For more information you can look at Microsoft's Visual Basic documentation.