5miles
  • Excel
  • VBA
  • Power BI
  • Powerpoint
  • Teams
  • Outlook
  • 5miles.nl

VBA

Learn which Excel tasks can be automated. Discover what VBA can do, how to run a script and record a macro. Learn how to create more powerful and complicated scripts and build your own personal VBA library.

ActiveX controls for VBA
VBA

ActiveX controls for VBA

Check out the use of ActiveX Controls for your VBA model and see how you can link macros to ActiveX Control buttons to improve the overall appearance of your model.

  • Erika
    Erika
3 min read
Improve VBA macro structure and speed
VBA

Improve VBA macro structure and speed

Navigate ways you can improve the structure and speed of your VBA macros.

  • Erika
    Erika
4 min read
Remove unnecessary Selects in VBA
5miles

Remove unnecessary Selects in VBA

Don't litter your VBA code with Select, know when to remove it. By simplifying your VBA code, you can see an increase in their performance (runtime).

  • Erika
    Erika
2 min read