Coding Overview

There are three main parts of the code to make the ToDo List work:

1. Workbook Code This is code that is directly related to the Workbook – mainly one sub Workbook_SheetChange that is triggered by Excel when a user changes something. This also contains a couple of constants referring to the column numbers and the code to build the text to be sent by mail.
2. Module ToDo This module contains the code changing todo list items like calculating relevance, filtering and updating. It also contains constants for the status and relevance values. It changes some contents of the sheet, so it’s not completely decoupled from the sheet, but if required, the required changes are pretty minimal. This could be code in the workbook, but Excel insists that some types of code (like user defined functions) have to be in a module.
3. Module Mail This is a pretty much self contained module to send an email over SMTP. Most code is a number of constant definitions to properly call the mail sending.

The code in each of these parts is described in the following posts:

• Automatically updating a changed item
• Calculating the relevance
• Updating the AutoFilter
• Sending an EMail

Next: Automatically updating a changed item.