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
X