5 Best VBA Practices | VBA to Excel | #shorts #vba #excel #automation

preview_player
Показать описание
5 best VBA practices for everyone

1. Always use Option Explicit
2. Use Error Handling
3. Add comments to your code
4. Use sheet names and 'ThisWorkbook'
5. Use 'With' whenever possible

These are only my observations based on 10 yrs of experience. Do you have some more tips. Feel free to write on comments. Thanks

Music : Bensound

#exceltips #vbatoexcel
Рекомендации по теме
Комментарии
Автор

who wouldve thought a former spreadsheet could become a gui development toolkit lmao..

nkdcwkp
Автор

Declaring variables is a pain in the ass, Python made me spoiled

olgaszoke
Автор

But 4th is waste of time
Instead use just a code name of the sheet😊

muhammadkausar