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 12, 2016

Budget Vacation Dashboard

My fiancé and I love to travel! We have already looked at flights for trips or family get-togethers on multiple occasions. We are budget conscious and try to remain frugal. Because of this, we spend high amounts of time searching for the cheapest flight. I have created a solution using VBA code to shorten the research time required in this process. My solution allows the user to select multiple destinations from a list of favorites, enter other trip data, set a trip budget and pull flight information from kayak.com. Results are shown in a spreadsheet with within-budget flights highlighted in green. The user can click a button to go online and book the flight as well as track historical prices on a separate tab. 

No comments:

Post a Comment

Blog Archive