Brochure
Enquire
- Welcome to Microsoft Word VBA Macro Programming
- What is involved in learning Word VBA?
- Getting Set Up (DOWNLOAD EXERCISE FILES HERE!)
- The Developer Tab and Macro Security
- Recording a Macro
- Attaching Macros to the Quick Access Toolbar
- Assigning a keyboard shortcut to a macro
- Editing a Recorded Macro
- The Benefits and Limitations of the Macro Recorder
Quick Facts
| particular | details | |||
|---|---|---|---|---|
|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
Fees information
₹ 3,499
certificate availability
Yes
certificate providing authority
Udemy
The syllabus
Getting Started
Writing Macros in the Visual Basic Editor
- Understanding the Project Explorer
- Other VBE Windows and Toolbars
- Macros and Subroutines
- Getting Help on VBA and the Word Object Model (Part 1)
- Getting Help on VBA and the Word Object Model (Part 2)
- Setting VBE Options (Part 1)
- Setting VBE Options (Part 2)
- Setting Project Options
Variables and Constants
- Initialising and Populating Variables
- Variable Data Types (Part 1)
- Variable Data Types (Part 2)
- String Variables
- Number Variables
- Date Variables
- Declaring Constants
- Using Object Variables
Subroutines and Functions
- Defining and Calling Subroutines
- Defining and Calling Functions
- Passing Arguments
- Using Optional Arguments
- Variable Scope
Conditionals, Loops and Arrays
- If Statements
- Select Case Statements
- For...Next Statements (Part 1)
- For...Next Statements (Part 2)
- Do…Loop Statements
- While…Wend Statements
- Using Array Variables (Part 1)
- Using Array Variables (Part 2)
- Working with Dynamic Arrays
The Word Object Model
- Understanding the Word Object Model
- Working with Object Methods
- Working with Object Properties
- Referring to objects within a collection
- Referencing Versus Selection and Activation
- Testing for the Existence of an Object
- Removing Objects from a Collection
Events, Dialogs and UserForms
- Overview of Event Programming
- Working with Document Events (Part 1)
- Working with Document Events (Part 2)
- Using Built-in Dialogs
- Creating a UserForm (Part 1)
- Creating a UserForm (Part 2)
- Creating UserForm Event-Handlers (Part 1)
- Creating UserForm Event-Handlers (Part 2)
- Validating User Input
Error Handling and Debugging
- Implementing Error Handling
- VBE Error Trapping Options
- Using On Error Resume Next
- Using the Err object
- Debugging via output
- Stepping through Code
- Using Watches to Monitor Values
Additional Step-by-Step Practice
- Obtaining the course files
- Overview of Project
- Creating the Launch Macro
- Creating the UserForm
- Listing File Names in the Listbox Control
- Updating the Preview Text Box
- Programming the Remove Button
- Programming the Move Up and Move Down Buttons
- Programming the Cancel Button
- Programming the Main Action Button Part 1
- Programming the Main Action Button Part 2
More from Grant Gamble
- Advanced Word VBA Macro Programming
- Power BI Excel Integration
- Power BI SQL Server Integration
- Power BI DAX What-if Parameters
- Power BI Sales Pipeline Analytics and Visualization
- Welcome to Power BI Parameters, Templates and RLS
Articles
Popular Articles
prev
next
