Setup Menus in Admin Panel

  • LOGIN
  • No products in the basket.

Course Curriculum

Getting Started
Welcome to Microsoft Word VBA Macro Programming 00:15:00
What is involved in learning Word VBA? 00:15:00
Getting Set Up 00:15:00
The Developer Tab and Macro Security 00:15:00
Recording a Macro 00:15:00
Attaching Macros to the Quick Access Toolbar 00:15:00
Assigning a keyboard shortcut to a macro 00:15:00
Editing a Recorded Macro 00:15:00
The Benefits and Limitations of the Macro Recorder 00:15:00
Writing Macros in the Visual Basic Editor
Understanding the Project Explorer 00:15:00
Other VBE Windows and Toolbars 00:15:00
Macros and Subroutines 00:15:00
Getting Help on VBA and the Word Object Model (Part 1) 00:15:00
Getting Help on VBA and the Word Object Model (Part 2) 00:15:00
Setting VBE Options (Part 1) 00:15:00
Setting VBE Options (Part 2) 00:15:00
Setting Project Options 00:15:00
Variables and Constants
Initialising and Populating Variables 00:15:00
Variable Data Types (Part 1) 00:15:00
Variable Data Types (Part 2) 00:15:00
String Variables 00:15:00
Number Variables 00:15:00
Date Variables 00:15:00
Declaring Constants 00:15:00
Using Object Variables 00:15:00
Subroutines and Functions
Defining and Calling Subroutines 00:15:00
Defining and Calling Functions 00:15:00
Passing Arguments 00:15:00
Using Optional Arguments 00:15:00
Variable Scope 00:15:00
Conditionals, Loops and Arrays
If Statements 00:15:00
Select Case Statements 00:15:00
For…Next Statements (Part 1) 00:15:00
For…Next Statements (Part 2) 00:15:00
Do…Loop Statements 00:15:00
While…Wend Statements 00:15:00
Using Array Variables (Part 1) 00:15:00
Using Array Variables (Part 2) 00:15:00
Working with Dynamic Arrays 00:15:00
The Word Object Model
Understanding the Word Object Model 00:15:00
Working with Object Methods 00:15:00
Working with Object Properties 00:15:00
Referring to objects within a collection 00:15:00
Referencing Versus Selection and Activation 00:15:00
Testing for the Existence of an Object 00:15:00
Removing Objects from a Collection 00:15:00
Events, Dialogs and User Forms
Overview of Event Programming 00:15:00
Working with Document Events (Part 1) 00:15:00
Working with Document Events (Part 2) 00:15:00
Using Built-in Dialogs 00:15:00
Creating a User Form (Part 1) 00:15:00
Creating a User Form (Part 2) 00:15:00
Creating User Form Event-Handlers (Part 1) 00:15:00
Creating User Form Event-Handlers (Part 2) 00:15:00
Validating User Input 00:15:00
Error Handling and Debugging
Implementing Error Handling 00:15:00
VBE Error Trapping Options 00:15:00
Using On Error Resume Next 00:15:00
Using the Err object 00:15:00
Debugging via output 00:15:00
Stepping through Code 00:15:00
Using Watches to Monitor Values 00:15:00
Additional Step-by-Step Practice
Overview of Project 00:15:00
Creating the Launch Macro 00:15:00
Creating the User Form 00:15:00
Listing File Names in the List Box Control 00:15:00
Updating the Preview Text Box 00:15:00
Programming the Remove Button 00:15:00
Programming the Move Up and Move Down Buttons 00:15:00
Programming the Cancel Button 00:15:00
Programming the Main Action Button Part 1 00:15:00
Programming the Main Action Button Part 2 00:15:00
The Application Object
Application.UserName 00:15:00
Application.System 00:15:00
Application.OnTime 00:15:00
Application.FontNames 00:15:00
The Document Object
Processing all Files in a Folder 00:15:00
Archiving Old Files 00:15:00
The Documents Collection 00:15:00
Testing Whether a Document is Open 00:15:00
Creating, Opening and Closing Documents 00:15:00
The Range and Selection Objects
The Range and Selection Objects compared 00:15:00
Verifying the Selection Type 00:15:00
Verifying the Selection Story 00:15:00
Verifying Selection or Range Information 00:15:00
Working with Text
Working with Paragraphs 00:15:00
Working with Words and Characters 00:15:00
Copying Text 00:15:00
Inserting Text 00:15:00
Using the Find Object 00:15:00
Changing the Case of Text 00:15:00
Working with Lists 00:15:00
Formatting text 00:15:00
Working with styles 00:15:00
Creating a Table of Contents 00:15:00
Sections, Headers and Footers
Creating Sections 00:15:00
The Page Setup Object 00:15:00
Creating Headers and Footers 00:15:00
The LinkToPrevious Property 00:15:00
Odd and Even Headers and Footers 00:15:00
Inserting Page Numbers 00:15:00
Inserting an Image into a Header 00:15:00
Working with Tables
Creating Tables 00:15:00
Merging cells 00:15:00
Formatting Tables 00:15:00
Converting Text to a Table 00:15:00
Transposing a table 00:15:00
Sorting Table Data 00:15:00
Content Controls and Interactive Forms
Customizing Placeholder Text 00:15:00
Creating Content Controls Programmatically 00:15:00
Control Events 00:15:00
Drop-down Lists and Combo Boxes 00:15:00
Using the Picture Control 00:15:00
Distributing Your VBA Solutions
Distributing raw VBA code 00:15:00
Distributing a VBA module 00:15:00
Distributing a Word Addin 00:15:00
Targeting Other Office Programs
Referencing other Office Applications 00:15:00
Controlling Excel from a Word Macro 00:15:00
Controlling Outlook from a Word Macro 00:15:00
Controlling PowerPoint from a Word Macro 00:15:00

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

PRIVATE COURSE
  • PRIVATE
  • 1 week, 3 days
0 STUDENTS ENROLLED

    TOP RATED COURSES

    Reviews

    Template Design © eTraining.Online All rights reserved.
    X