In this article we use some VBA to remember which worksheet you have navigated away from, so that a ‘Go Back’ button can be placed to return to it. We start with a menu page that has buttons navigating to our 4 worksheets. 1) Press Alt+F11 to open your VBA window. From Read More …
Month: March 2016
Adding a scroll bar in Excel
This article will demonstrate how to add a basic scroll bar in Excel with an example of how it could be used on your dashboard. We’ve taken a full year of ATP tennis matches from 2015 (credit to www.tennis-data.co.uk for the source data). The dashboard is going to show tennis stats by month and the Read More …