These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Tuesday, April 19, 2011

Grocery List Builder

Executive Summary

The “Grocery List Builder” is an Excel-based, VBA-powered tool which allows the user to quickly create a grocery list with an easy-to-use user form. The multi-page form is broken out into nine different grocery categories, with a selection screen and a details screen for each category (thus 18 screens total). The user calls the form by pressing either the “Make List” button on the Grocery List Builder dashboard or the “Edit List” button on the mini-dashboard in the Grocery List view. The user can move from tab to tab within the form either by clicking on the individual tabs at the top of the form or by navigating through with the “Next” and “Back” buttons at the bottom of the form. The form features various message boxes to help guide the user as he or she selects the items to complete his or her list (for example, one message box alerts the user if 14 items, the maximum, have been added for any given category).

The user can add up to 14 grocery items per category and can enter details such as quantity (in a drop down selection) and notes (i.e., brand name, size, etc. in a text box). The selections are automatically copied to the Grocery List template in the Excel workbook, which can be printed instantly by clicking the “Print List” button on either the Grocery List Builder dashboard or the mini-dashboard in the Grocery List view.

In addition to the tool’s main feature, the Grocery List Builder, this tool also features a recipe selector. The user can access this part of the tool from the main dashboard by clicking “Select Recipes”; in addition, when the user clicks “Finished” on the Grocery List Builder form, he or she has the option to select recipes before finishing. As with the Grocery List view, the tool features a Selected Recipe view which includes a mini-dashboard. The recipe selector allows the user to not only select up to six recipes to print on “cards,” but also allows the user to add the recipe ingredients to a special section of the grocery list. The selected recipes are copied to the Recipes template in the Excel workbook, which can be printed instantly by clicking the “Print Recipes” button on either the Grocery List Builder dashboard or the mini-dashboard in the Selected Recipes view.

Project Write Up
Project File

No comments:

Post a Comment

Blog Archive