Skip to main content
ExcelBaby.com
Course
Getting Started with Excel
Excel Formulas and Functions
Excel Troubleshooting
Programming with Excel VBA
Excel VBA and Macro Examples
Docs
Learn
Functions
Questions
Shortcuts
Resources
Books
Home
»
Programming with Excel VBA
»
VBA Programming Fundamentals
»
Page 2
VBA Programming Fundamentals
Learn for free
Course content
64-bit Visual Basic for Applications overview
Avoiding naming conflicts
Calling procedures with the same name
Calling property procedures
Calling Sub and Function procedures
Creating object variables
Creating recursive procedures
Declaring variables
Declaring arrays
Declaring constants
Early and Late Binding
Excel VBA Code Names
Executing code when setting properties
How AutoSave impacts add-ins and macros
Looping through code
Making faster For...Next loops
Passing arguments efficiently
Put Double Quotes in a String in Excel VBA
Returning strings from functions
Sheets Vs. Worksheets in Excel VBA
The Difference Between Empty, Null and Nothing in VBA
Understanding Visual Basic syntax
Understanding Variants
Understanding parameter arrays
Understanding automation
Understanding scope and visibility
Understanding the lifetime of variables
Understanding objects, methods, properties, and events
Understanding conditional compilation
Understanding named arguments and optional arguments
Using arrays
Using constants
Using data types efficiently
Using events with the Application object
Using For Each...Next statements
Using the Add-In Manager
Using parentheses in code
Using With statements
Using Do...Loop statements
Using For...Next statements
Using If...Then...Else statements
Using Select Case statements
VarType constants
VBA document conventions
VBA Compiler constants
VBA naming rules
Working across applications
Writing a Function procedure
Writing a property procedure
Writing a Sub procedure
Writing declaration statements
Writing data to files
Writing executable statements
Writing VBA statements
Where should I put the Excel VBA code?
Writing assignment statements
Course Details
Language
English
Last Update
July 22, 2022
Requirements
Microsoft Office Excel any version
Course level
All students
