Visual Basic Editor OverviewĪll of the Windows in the Visual Basic Editor can be re-sized, moved or even hidden from the Editor to increase the space allowed for other Windows. The Visual Basic Editor in Excel can seem a bit daunting the first time you see it but fear not it becomes easier with a little bit of knowledge.
When the Developer Tab is selected the Excel Ribbon will change to look similar to below:įor now we will focus on the Code sub-section of the Ribbon (far left in most cases) as that contains an icon for Visual Basic, if you click on that icon you open up the Visual Basic Editor in Excel. If the Developer Tab is not on show in the Ribbon when you open your Excel workbook then you need to change the Excel Options to show it and there is a quick post here for those of you in that position…work through that quickly and return. The Visual Basic Editor in Excel or VBE for short is found under the Developer tab in the Excel Ribbon. In this post we will cover how you locate the Editor and what the different windows in the Editor mean, this is invaluable Excel VBA learning and it will give you a solid foundation to work with going forward…
Following on from the Beginners Introduction to Excel VBA this post will look at the Visual Basic Editor in Excel.
0 kommentar(er)
