Customize the VB Editor || Excel VBA Master Class || 1.3.3
As a VBA Developer, we will spend most of our time within the VB Editor. So, in this lesson, we will explore the options available to us to make our coding experience better.
We will look at the:
Editor Tab
1. Auto Syntax Check
2. Require Variable Declaration
3. Auto List Member
4. Auto Quick Info Options
5. Auto Data Tips
6. Auto Indent Setting
7. Drag and Drop Text Editing
8. Default to Full Module View
9. Procedure Separator
Editor Format Tab
Font Colour, Size and Style
General Tab
Error handling/ break on unhandled errors
Docking Tab
Fix our windows to the edge of our screen.
#vba #excel
Follow the rest of the series, in the below playlist:
• VBA MasterClass
00:00 Intro
00:24 Editor Tab
06:38 Editor Format Tab
07:20 General Tab
09:44 Docking Tab
