Developer and VBA Starting Point Firstly you will want to add in the Developer tab to your excel ribbon. File > Excel options > Customise Ribbon Tick the Developer Option. Adding a button to a page Many of the VBA scripts we use here start with a button, here is how to add the […]
Use Buttons to Navigate Sheets
This a quick simple way to show how to use buttons to navigate the on the to different worksheets. From Developer tab, create a new button and assign the following macro to it. Heres the code – Part in Bold you will need to change to the sheet you want. Sub Button1_Click() ThisWorkbook.Sheets(“Worksheetname“).Activate End Sub Nice […]