Page Index - danielep71/VBA-PERFORMANCE GitHub Wiki

40 page(s) in this GitHub Wiki:

• Home
• Additional Reference libraries
• Avoid activating and selecting
• Class cPerformanceMonitor
• Concatenate strings using Mid$ Function
• Conclusions
• Convert to string: Str$ vs CStr
• Copy Paste
• Declare variables Use Option Explicit
• Disable Events
• Disable Screen Updating
• Disable Status Bar
• Disable time wasters
• Edit recorded macros
• Fixed length strings vs variable length strings
• GetTickCount (Kernel Timer)
• High resolution timer
• How to use this class
• Improve perceived performance
• Macro Optimization
• Measure
• Micro Optimization
• Page Breaks
• Progress Bar
• Reduce the number of lines using comma "," or colon ":"
• Splash Screen
• String functions: $ vs $ less
• Testing an empty string: different methods
• The fastest way to swap strings
• The Optimization Process
• The test environment
• TimeGetSystemTime
• TimeGetTime (Multimedia Timer)
• Turn off Automatic Calculation
• Use "With" statement
• Use vbNullString instead of ""
• Useful links
• VBA Now()
• VBA Timer
• Writing efficient alghoritms