How to set up VBA editor to make it looks like a pro - Simple Excel VBA
Вставка
- Опубліковано 2 сер 2024
- In this video You will learn How to set up VBA editor to improve your user experience!
simpleexcelvba.com/customize-...
0:00 Intro
1:32 Auto Syntax Check
3:36 Require Variable Declaration
5:18 Colors of VBE
7:20 Comment/ Uncomment Block
9:16 Definition & Last Position
11:58 Summary & Outro
MY EQUIPMENT:
○ Microphone - amzn.to/3JidXEt
○ Keyboard - amzn.to/3sAMckx
○ Mouse - amzn.to/3euvwmn
○ Monitor - amzn.to/3qoJITq
Please like and subscribe my channel, it means a lot for me :)
Website: simpleexcelvba.com/
Facebook: / simpleexcelvba
Pinterest: / simpleexcelvba - Наука та технологія
Liked it a lot. I am also a VBA programmer and just started one channel teaching how to use openGL in Excel (Programando em Excel para todos)
Thank you!
Underrated tips. Thank you so much for this ! VBA is fugly, but at least this looks better :D Thanks
Thank You, appreciate that :)
THANK YOU!!!! I can't believe I worked so hard without knowing this.
:)
Wonderful quality of life advice for working in vba. Thank you
You're welcome :)
Do you know if it's possible to use an alternative VBA editor in Microsoft Office applications? The problem with the default VBA editor for Office is that on high resolution monitors it is impossible to increase the font size to the code area. I tried changing the font size on the menu TOOLS - OPTIONS - EDITOR FORMAT, but it didn't work. The command wasn't accepted. Somehow the font size to code area in default VBA editor is directed related to monitor resolution.
You can change the font size to 24 size, not more.
Yes, You can try Visual Studio Code and connect with some VBA plugin to your worksheet.