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
  • Наука та технологія

КОМЕНТАРІ • 10

  • @claudineyribeiro518
    @claudineyribeiro518 7 місяців тому +1

    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)

  • @halestone3903
    @halestone3903 4 місяці тому

    Thank you!

  • @Mindinmatrix
    @Mindinmatrix Рік тому +1

    Underrated tips. Thank you so much for this ! VBA is fugly, but at least this looks better :D Thanks

  • @Kanibulus
    @Kanibulus 7 місяців тому

    THANK YOU!!!! I can't believe I worked so hard without knowing this.

  • @anotherplatypus
    @anotherplatypus Рік тому +1

    Wonderful quality of life advice for working in vba. Thank you

  • @Esclarecidos
    @Esclarecidos 3 роки тому

    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.

    • @SimpleExcelVBA
      @SimpleExcelVBA  3 роки тому

      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.