Moving from MZ-Tools 3.0 to 8.0 Part 5: A Task List for the VBA editor

Users of MZ-Tools 3.0 for VB6 always enjoyed a task list for VB6 (actually it was introduced in MZ-Tools 2.0), but users of MZ-Tools 3.0 for VBA didn’t have such feature because technically MZ-Tools 3.0 for VB6 used the .vbp file of the project to store the tasks. Alas, MZ-Tools 3.0 for VBA couldn’t use the .mdb or .xls file of the Office documents. Since quite a few users requested a task list for the VBA editor, MZ-Tools 8.0 for VBA provides it. The task storage problem is solved using a separate “.Tasks.xml” file that accompanies the Office file (the same approach is used by MZ-Tools 8.0 for VB6):

TaskFile

Not a surprise then that you can’t get a task list until your Office document or VB project is saved:

TaskListSaveRequired

Once saved, you can start creating tasks until you populate the list, which is virtually identical to the one provided by MZ-Tools 3.0:

TaskList

For each task, you can enter a description, priority (high, normal, low), status, assigned person and multi-line comment:

TaskEditor

Some or all of the tasks can be exported to a separate file, for whatever use, and they can be imported too:

TaskListExport

One difference with the task list provided by MZ-Tools 3.0 for VB6 is that there is a single filter at the top-right corner (rather than separate filters for priority, status, etc.). In that filter you can enter any text and the list will show only tasks containing that text:

TaskListFilter