Custom Excel Workbooks: Examples

In order to use these files, you must enable macros. These files were created in the hopes that they will be useful, but without warranty of any kind.

Travel Checklist

This is a simple example created mostly for personal use. On the Full List tab, you can add categories and items to your list. On the Checklist page, click "Add Items". This will bring up a userform with your list (from the "Full List" tab). Select the items you want to add to your list. It goes down to row 64 for the first column (2nd column will continue down). This file could have other uses such as any type of To-Do Checklist. (Ignore the Code Formulas tab - this is used for the VBA code.)

Checkbook

This Excel file has a lot of notes throughout and should be pretty self-explanatory. There are notes on the Start tab.

Add commonly used descriptions on the Totals page (such as Utility payments).

On the Checking (or Savings) tab, click "Enter Info". There is a calendar control on this userform, BUT not everyone has it installed (or the same version), so you may see a blank space.

Charts

Really simple charts (no macros in this one).

divider

divider