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-vba
VBA Best Practices
Fastest Entity Framework Extensions
Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
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
Got any excel-vba Question?
Ask any excel-vba Questions and Get Instant Answers from ChatGPT AI:
ChatGPT answer me!
PDF
- Download
excel-vba
for free
Previous
Next
Cookie
This website stores cookies on your computer.
We use cookies to enhance your experience on our website and deliver personalized content.
For more details on our cookie usage, please review our
Cookie Policy
and
Privacy Policy
Accept all Cookies
Leave this website