Set the VBA IDE Options
Set the VBA IDE
Options
Editor Format
The Editor tab
specifies the Code window and Project window settings.
Code settings
include
- Auto Syntax Check
- Require Variable Declaration
- Auto List Member
- Auto Quick Info
- Auto Data Tips
- Auto Indent
- Tab Width
Window
settings include
- Drag and Drop Text Editing
- Default to Full Module View
- Procedure Separator Display