VBA Danny Stakland

Executive Summary

At the beginning of the semester I had to create a project plan for my on-campus internship.  It was very difficult to do and I wasn’t able to see it alongside other things I was doing so it was very difficult to keep using it.  For my project I created a program that uses user forms to create project plans and shows different projects alongside each other.  I will be able to use this for creating plans for work, but also for tracking school assignments and for any personal projects that I have going.

The system consists of a ribbon with buttons for adding projects as well as editing the categories that projects go under.  The main form is used to add projects and allows for the input of all the information necessary to do the project.  As part of this form there is a secondary form for adding steps.  Each project has to have at least one step and the steps include the number of hours that it will take, a description, as well as start and finish dates. 

When a new project is created it is given its own sheet with the steps laid out in chronological, descending order.  There is one overview worksheet that has a similar format to the project sheets but includes steps from all the projects.

Project Write Up: http://files.gove.net/shares/files/13w/stakland/SD_write_up.pdf
Project File: http://files.gove.net/shares/files/13w/stakland/Project_Management.xlsm