Microsoft Excel Macro VBA Programming (Advanced)

This course covers aspects of developing macros for practical applications. New and advanced tools have been included in this course.

Free

Microsoft Excel Macro VBA Programming (Advanced)

2 days
All levels
0 lessons
0 quizzes
0 students

Course Info

This course covers aspects of developing macros for practical applications. New and advanced tools have been included in this course.

Pre-requisites

Completion of Microsoft Excel VBA (Fundamentals of Macro)

Course Outline for This Programme

  • Introduction
  • Message Box
  • Input Box
  • The Excel Inputbox Method
  • With… End Statement
  • GoTo Statement
  • Select Case Statement
  • Using Arrays
  • Creating Multi-Dimensional Array
  • Introduction
  • Function examples
  • Categorising & Adding Function Description
  • Introduction
  • Inserting a New Userform
  • Adding controls to a Userform
  • Setting A Control’s properties
  • Creating a Userform: An Example
  • Adding More Controls to the Toolbox
  • Userform “Menu”
  • Tool Bar “Menu”
  • Command Bar Menu
  • Creating A Short Cut Key
  • Adding & Deleting Menu Automatically
  • What Is An Add-In?
  • Creating An Add-In
  • Loan Calculator Application
  • Data Entry Application
Curriculum is empty