logo rip
RIP Tutorial
  • Tags
  • Topics
  • Examples
  • eBooks
Download excel-vba (PDF)

excel-vba

  • Getting started with excel-vba
  • Awesome Book
  • Awesome Community
  • Awesome Course
  • Awesome Tutorial
  • Awesome YouTube
  • Application object
  • Arrays
  • autofilter ; Uses and best practices
  • Binding
  • Charts and Charting
  • Common Mistakes
  • Conditional formatting using VBA
  • Conditional statements
  • Creating a drop-down menu in the Active Worksheet with a Combo Box
  • CustomDocumentProperties in practice
  • Debugging and Troubleshooting
  • Excel VBA Tips and Tricks
  • Excel-VBA Optimization
  • File System Object
  • How to record a Macro
  • Locating duplicate values in a range
  • Loop through all Sheets in Active Workbook
  • Merged Cells / Ranges
  • Methods for Finding the Last Used Row or Column in a Worksheet
  • Named Ranges
  • Pivot Tables
  • PowerPoint Integration Through VBA
  • Ranges and Cells
  • SQL in Excel VBA - Best Practices
  • Use Worksheet object and not Sheet object
  • User Defined Functions (UDFs)
  • VBA Best Practices
    • Always define and set references to all Workbooks and Sheets
    • ALWAYS Use "Option Explicit"
    • Avoid re-purposing the names of Properties or Methods as your variables
    • Avoid using ActiveCell or ActiveSheet in Excel
    • Avoid using SELECT or ACTIVATE
    • Document Your Work
    • Error Handling
    • Never Assume The Worksheet
    • Switch off properties during macro execution
    • Use descriptive variable naming
    • Use VB constants when available
    • Work with Arrays, Not With Ranges
    • WorksheetFunction object executes faster than a UDF equivalent
  • VBA Security
  • Workbooks
  • Working with Excel Tables in VBA


excel-vba

  • Getting started with excel-vba
  • Awesome Book
  • Awesome Community
  • Awesome Course
  • Awesome Tutorial
  • Awesome YouTube
  • Application object
  • Arrays
  • autofilter ; Uses and best practices
  • Binding
  • Charts and Charting
  • Common Mistakes
  • Conditional formatting using VBA
  • Conditional statements
  • Creating a drop-down menu in the Active Worksheet with a Combo Box
  • CustomDocumentProperties in practice
  • Debugging and Troubleshooting
  • Excel VBA Tips and Tricks
  • Excel-VBA Optimization
  • File System Object
  • How to record a Macro
  • Locating duplicate values in a range
  • Loop through all Sheets in Active Workbook
  • Merged Cells / Ranges
  • Methods for Finding the Last Used Row or Column in a Worksheet
  • Named Ranges
  • Pivot Tables
  • PowerPoint Integration Through VBA
  • Ranges and Cells
  • SQL in Excel VBA - Best Practices
  • Use Worksheet object and not Sheet object
  • User Defined Functions (UDFs)
  • VBA Best Practices
    • Always define and set references to all Workbooks and Sheets
    • ALWAYS Use "Option Explicit"
    • Avoid re-purposing the names of Properties or Methods as your variables
    • Avoid using ActiveCell or ActiveSheet in Excel
    • Avoid using SELECT or ACTIVATE
    • Document Your Work
    • Error Handling
    • Never Assume The Worksheet
    • Switch off properties during macro execution
    • Use descriptive variable naming
    • Use VB constants when available
    • Work with Arrays, Not With Ranges
    • WorksheetFunction object executes faster than a UDF equivalent
  • VBA Security
  • Workbooks
  • Working with Excel Tables in VBA

excel-vbaVBA Best Practices


Remarks

We all know them, but these practices are far less obvious to someone starting to program in VBA.


VBA Best Practices Related Examples

  • Always define and set references to all Workbooks and Sheets
  • ALWAYS Use "Option Explicit"
  • Avoid re-purposing the names of Properties or Methods as your variables
  • Avoid using ActiveCell or ActiveSheet in Excel
  • Avoid using SELECT or ACTIVATE
  • Document Your Work
  • Error Handling
  • Never Assume The Worksheet
  • Switch off properties during macro execution
  • Use descriptive variable naming
  • Use VB constants when available
  • Work with Arrays, Not With Ranges
  • WorksheetFunction object executes faster than a UDF equivalent
PDF - Download excel-vba for free


Previous Next
This modified text is an extract of the original Stack Overflow Documentation created by following contributors and released under CC BY-SA 3.0
This website is not affiliated with Stack Overflow