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

Monday, April 12, 2010

Day Planner - Howard Kuan - Winter 2010

My project was to facilitate the access of one's database of contacts and history. This tool is not only effective in action items searching but also efficient in making priorities for your time. The database includes customers, friends and family. Hope you find this tool helpful and make the most use of it to achieve you life goals.

The benefits of this tool are in the following:
  • Prevents you from missing action items by listing ALL the action items to date
  • You can choose the priority by yourself. The list in turn is rearranged into your order
  • You can update your memo to the existing database for your reference in the future
  • In order to balance your life in networking and family. The "Day Planner" tool contains friends and family (especially for big Mormon families) categories
  • The number of items is limited to 10 for a more effective priority. After you finish the first 10 items, you can run this tool again to deal with the next 10 items. The numbers for friends and family are limited to 5

The code contains three parts: search engine, prioritizing and updating database. Please note that when you establish your database, you need to add comments for all your date cells. Also please be aware that if there are more than 100 items in any one of the categories in your database, you need to define a larger array for your data.

Download file: VBA_prj_howard
Download document: write-up_howard

No comments:

Post a Comment

Blog Archive