CLASSROOM
TENTATIVE

SCHEDULES


Feb 3, 2018 9:00 am 18:00 pm
Feb 10, 2018 9:00 am 18:00 pm
REGISTER NOW

MICROSOFT

MACROS AND INTRODUCTION TO VBA 2013

DESCRIPTION
COURSE CONTENT

Recording Macros

  • Exploring Macro Security
  • Recording and Running a Macro
    • Using Relative Reference
  • Assigning a Macro to an Image or Button

 

VBA Programming

  • Essential VBA Codes
  • Using IF in VBA
  • Creating Loops and Other Decision Structures
  • Interactive Elements
  • Other Object Programming

 

Functions

  • Designing Own Functions
  • Writing Formulas in VBA
  • Using Excel Functions in VBA
  • VBA Functions

  

Userforms

  • Designing Userforms
  • Adding Operations on Userform

 

Creating Modules

  • Design Strategies
  • Error Handling