Excel Custom Navigation: Excel VBA for Beginners

INTRODUCTION

What is an Excel custom navigation system? Switching between sheets, unless using keyboard shortcuts, means moving the mouse pointer all the way to the bottom of the screen. With multiple sheets and workbooks, this can be onerous – is there a better way?

Click here to download the STARTER file.
Click here to download the COMPLETE file.

Video 1 – INTRODUCTION

Watch Chris describe what the Excel custom navigation system is, why it helps, and how to create it.

The Excel custom navigation system is a neat alternative. It positions navigation buttons at the top of the worksheet, not at the bottom, facilitating smooth navigation. It also creates a distinctive visual effect, similar to a ‘cockpit’ or car dashboard, which gives the spreadsheet a professional look.

But, from the learning perspective, there is something more important. Building a custom navigation systems presents an opportunity to learn new coding techniques. Clearly, we do no want to have to create and position all the buttons manually! So, what coding techniques will allow us to do it quickly, precisely and minimise stress?

Excel Custom Navi

The Excel custom navigation system video series takes you through the main steps. We explore how to create multiple buttons, how to position them, how to trigger the right code, and how to copy them across sheets. Some of the code is quite intricate – you can see Chris get into a coding tangle, and work his way out!

Video 2 – Create a shape and duplicate it using VBA

Video 3 – Use VBA to position shapes

Video 4 – Use VBA to control text that appears in shapes

Video 5 – Use VBA to navigate to a sheet dynamically

Video 6 – Use VBA to copy / paste shapes across sheets


Why not try creating your own Excel custom navigation system? Let us know how you get on!

Read more about the #ExcelRevolution here. Or, follow us on Facebook and Twitter.

This entry was posted in Beginner Articles, Excel Guidance Articles, Excel Guidance Videos & Articles, Intermediate Articles, Uncategorized. Bookmark the permalink. Comments are closed, but you can leave a trackback: Trackback URL.