✅ Download the file | www.exceleinfo....
🏆 Subscribe | goo.gl/M5zNA8
I've been doing macros in Excel for many years and I'm constantly learning new things. The VBA language, although it has not been updated for many years, still has much to offer us. To be honest, I think there are still many years left before I think about being replaced by another language for Office. JavaScript?
In this article I am going to share 5 ways to improve your macros in Excel, although you can call them Tips or tricks. These are properties that I use constantly in my macros, so do not hesitate to continue reading, in addition to watching the Video.
1. Disable the screen updating when executing a macro.
2. Ask the end user if he wants to execute a macro.
3. Show custom message in the Status Bar.
4. Activate the manual calculation so that the macros are faster.
5. Disable alerts and Excel messages.
More examples | www.exceleinfo.com
More examples | blogs.itpro.es/...
Facebook Page | / exceleinfo
Get notificacions on Telegram | t.me/EXCELeINFO
Twitter | @EXCELeINFO
Twitter | @SergioACamposH
Download EXCELeINFO addin:
addin.exceleinf...
Photo by Ali Yahya on Unsplash
Негізгі бет 5 Tips to improve your Excel VBA macros @EXCELeINFO
Пікірлер: 30