Content Highlights

• Create A Macro Using The Macro Recorder
  • Visual Basic for Applications (VBA)
  • Object oriented Programming
  • Macros
  • Macro Options
  • The Macro Recorder
  • Personal Macro Workbook
  • Using The Macro Recorder 

• Edit A Macro
  • The Visula Basic Editor
  • Projects
  • Modules
  • The Module Folder
  • Objects
  • Properties
  • Methods
  • VBA Comments
  • How to Edit a Macro 

• Debug A Macro
  • The Debugging Process
  • Debugging Tools
  • How to Debug a Macro 

• Customizing The Quick Access Toolbar And Hotkeys
  • How to Customize the Quick Access Toolbar and Hotkeys 

• Set Macro Security
  • Digital Certificates
  • Digital Signetures
  • Macro Security Settings
  • How to Set Macro Security 

• Insert Text
  • The Selection Property
  • The ActiveSheet Property
  • The name Property
  • The Value Property
  • Concatenation
  • How to Insert Text 

• Format Text
  • How to Format Text

• Sort Data
  • The Range Object
  • The Select Method
  • The CurrentRegion Property
  • How to Sort Data 

• Duplicate Data
  • Data Type
  • Variables
  • Variables Name Rules
  • Operators
  • The Assignment Operator
  • Arithmetic Operators
  • Comparison Operators
  • Logical Operators
  • The For Next Loop
  • Do Loops
  • The Worksheets Objects
  • The Count Property
  • The Offset Property
  • The Copy Method
  • The Paste Method
  • How to Duplicate Data 

• Generate A Report
  • The Column Property
  • The Autofit Method
  • The address Property
  • The Call Statement
  • The Font Statement
  • The End Property
  • How to Generate a Report 

• Determine The Dialog Box Type
  • Message Boxes
  • Input Boxes

• Capture User Input
  • The InputBox Function
  • Constants
  • The MsgBox Function
  • The Code Continuation Character
  • The vbCrlf Constant
  • Decicion Structure
  • The Select Case Structure
  • The If Then Structure
  • The Else Clause
  • How to Capture User Input

• Insert, Copy, And Delete Worksheets
  • The Add Method
  • The Copy Method
  • The Delete Method
  • How to Insert, Copy, and Delete Worksheets

• Rename Worksheets
  • Expressions
  • The DateSerial 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 PrintPreview Method
  • The PrintOut Method
  • How to Print Worksheets

• Create User Defined Functions
  • User-Defined Functions
  • Types of Functions
  • Arguments
  • How to Create User-Define 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