Excel Macros & VBA (Day 2 of 2)
Prerequisites
Excel Macros & VBA (Day 1 of 2)
DAY 2
Creating an Interactive Worksheet
- Determine the Dialog Box Type Message Boxes
- Input Boxes
Capture User Input
- The Input Box Function
- Constants
- The Msg Box Function
- The Code Continuation Character
- The vbCrLf Constant
- Decision Structures
- The Select Case Statement
- The If Then Structure
- The Else Clause
- How to Capture User Input
Working with Multiple Worksheets
- Insert, Copy, and Delete Worksheets o The Add Method The Copy Method
- The Delete Method
- How to Insert, Copy, and Delete Worksheets
Rename Worksheets
- Expressions
- The Date Serial Function
- The Format Function
- How to Rename Worksheets
Modify the Order of Worksheets
- The Move Method
- How to Modify the Order of Worksheets
Print Worksheets
- The Print Preview Method
- The Printout Method
- How to Print Worksheets
Performing Calculations
- Create User-Defined Functions
- User-Defined Functions
- Types of Functions
- Arguments
- How to Create User-Defined Functions
Automate SUM Functions
- Declared Range Objects
- The Set Statement
- Range Object Cell Addressing
- The Rows Property
- The Formula Property
- The Columns Property
- Address Property Cell Reference Settings
- How to Automate SUM Functions