This is a short post showcasing some of the VBA procedures, classes, and coding techniques in last month’s bond ladder financial model. The model relies heavily on VBA, using it to manage displays, calculations, and data storage.
This post introduces a new financial model — an Excel/VBA implementation of a bond ladder portfolio and summary. Its general purpose is to calculate an average weighted yield for a ladder of bonds.
The aesthetic design of a spreadsheet, when done right, can add significant benefits in terms of usability and functionality.
The next few posts will focus on layout. While layout was previously discussed in some detail (listboxes and forms), we are yet to dive into overarching layout ideas and approaches.
Using VBA to control navigation elements of a spreadsheet provides a greater level of flexibility. Through proper coding, users will be provided with responsive navigation and proper feedback.
Excel shapes can serve as hyperlinks for spreadsheet navigation. By assigning links to shapes, spreadsheet developers have full flexibility in modifying a link’s size and look.
Navigating through an Excel workbook should be like navigating through a well designed website. By approaching projects with the mindset of good design, you can ensure great usability standards.
Nobody likes to open an Excel file with 30 tabs. While navigation may not be the most essential component of a spreadsheet’s functionality, it is should be considered the anchor of good spreadsheet design.