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 14, 2015

VBA Grocery List

Executive Summary

Project Objective:

Far too often people arrive home after
grocery shopping only to realize that they have forgotten to purchase one or
more essential grocery items for the upcoming week. Too often, I have found myself in this exact predicament. Forgetting an item is especially aggravating
when it is an essential ingredient in meals you were hoping to make that week.
The only solutions are to either go back to the store or revise your meal plans
for the upcoming week.

In an effort to solve this problem I have
created a VBA grocery list which ensures that users will always go to the
grocery store with a complete list of the ingredients they will need based on
what they want to make that week.

System Overview:

The VBA grocery list achieves the project
objectives by first offering users the ability to enter in all of the recipes
that they love to make. These recipes
are stored in a worksheet. When it is time
to go to the grocery store, the user clicks on the “make a list” button and is
prompted with the names of the recipes they entered into the system. Now the user only needs to choose which
recipes they want to make for the upcoming week and the program will
automatically compile a list of all necessary ingredients (and their quantity)
that the user will need to make their selected meals.

Before finalizing the list, the program
allows the user to go through and uncheck the ingredients that they already
have or modify the ingredient amounts.
Finally the program will group the items based on the food type (eg. dairy,
vegetables, etc…) and the user can click a button to print out the complete
grocery list.