Log In
EN
FR
Search
  • Excel Course
    • 1. The Basics
    • 2. Tables
    • 3. Size and Formatting
    • 4. Inserting Objects
    • 5. AutoFill series
    • 6. Functions and Calculations
    • 7. Graphs
    • 8. Conditional Formatting
    • 9. Supplements
    • 10. Using Databases
  • VBA Course
    • 1. Introduction
    • 2. Sheets and cells
    • 3. Variables
    • 4. Conditions
    • 5. Loops
    • 6. Procedures and functions
    • 7. Dialog boxes
    • 8. Events
    • 9. Forms and controls
    • 10. Arrays
    • 11. Supplements
    • 12. VBA tips
  • VBA Tips
    • Date and time
    • Formatting and text
    • Generators and calculations
    • UserForm and controls
    • Variables and arrays
    • Various
    • Worksheets and Workbooks
  • Functions Explained
    • Date and time
    • Logical
    • Lookup and reference
    • Math and trigonometry
    • Statistical
    • Text
  • Function List
    • Compatibility functions
    • Cube functions
    • Database functions
    • Date and time functions
    • Engineering functions
    • Financial functions
    • Information functions
    • Logical functions
    • Lookup and reference functions
    • Math and trigonometry functions
    • Statistical functions
    • Text functions
    • Web functions
  • Downloads
    • Accounting
    • Budget, account management
    • Calendars
    • Converters
    • Finance
    • Games
    • Health, nutrition
    • Leisure
    • Mathematical tools
    • Other management tools
    • Personnel managment
    • Sales management
    • Schedules
    • Sports
    • Utilities
    • Other Applications
VBA TIPSVBA TIPS
  • Date and time
  • Formatting and text
  • Generators and calculations
  • UserForm and controls
  • Variables and arrays
  • Various
    • Disable events
    • Excel's version
    • ScreenUpdating
    • Stop a running macro
    • Ternary operator
    • VBA obfuscator
  • Worksheets and Workbooks
SHARE

VBA Tips: Various

Various tips

  • Disable events
  • Perform an action depending on Excel’s version
  • Stop a running macro
  • Ternary operator
  • Using ScreenUpdating to speed up the execution of a macro
  • VBA code protection (obfuscator)

Excel Trainings

  • Free Excel Training
  • Free VBA Training

Excel-Pratique

  • Free VBA Obfuscator
  • Contact

Design and website: Sébastien Mathier © 2004-2020 - Terms of use