Excel Automation Using Macros and VBA 
Recording macros and Buttons
- Absolute and relative recording
- Where macros can be stored
- Assigning macros to Buttons
Visual Basic Programming Basics
- Getting help in VBA
- Create a subroutine
- Create a function
- Declare a variable
- Create a constant
- Comment your code
Working with cells
- Selecting cells (absolute)
- Selecting cells (relative)
- Selecting to the end of a block
- Selecting a range by its corners
- The VB code editor
- Using Project Explorer
- Creating modules
- Basic subroutines and comments
Working with ranges
- Using the range property
- Using the cells property
- Combine multiple ranges
- Using the offset property
- Resize a range
- Insert a range
- Set the width of columns in a range
Messages and variables
- Input boxes and message boxes
- Assign Values to Variables
- Declaring variables
Working with Excel Object Model
- An introduction to the Excel object model
- Using object browser
- Create an object variable
- Objects and collections
- Methods and properties
- Display a Built-in dialog box
Loops and conditions
- Simple IF conditions
- Multiple IF and SELECT … CASE
- Execute tasks a specific number of times
- Using the For Each Next Loop
|
