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 15, 2014

Lead Information

I created a VBA project for Homestar Windows.  This company is owned and operated by my father, Dave Orgill.  It specializes in vinyl replacement windows and doors.  The business has 12 employees including three secretaries, six salesmen, and 2 installation crews.  Homestar Windows advertises through a diverse range of mediums including Home Improvement magazines and newsletter subscriptions, Google Adwords, the radio, Angie’s List, Yelp, and Facebook.  Homestar diligently tracks how new customers heard about it.  It also employs the use of  This company produces 20 different phone numbers that Homestar utilizes.  A different phone number is used on each advertising medium.  When someone calls in, recognizes the phone number and matches it to an advertising source.  That way, Homestar knows where people are learning about its products.

My projects simplifies and automates the lead tracking process for Homestar’s lead secretary.  It allows the user to input new lead information, produces executive level lead information, and brings in comparative data from

No comments:

Post a Comment

Blog Archive