|
|
|---|---|
.JPG)
Training - VBA - Task Oriented Training
Modes
I offer public training courses - where you can join users from other organizations in a common shared-cost day or more of training.
I offer private training courses - where you as an individual, or as an organization, can benefit by focusing on a training course customized to your needs.
I offer FREE correspondence training courses - where you as an individual can receive emails at a rate best suited to your needs, on a variety of topics. Such courses are designed to give you an introduction to a complex topic such as VBA, or to boost and refresh your skills (for example "Windows Tips") without having to leave your desk.
VBA - Task Oriented Training
Task Oriented Training is a collection of modules, each based on a real programming task that I have performed.
For example "Opening The VBE" teaches how to open the Visual Basic Editor by program code from within a VBA procedure.
"Calculate Third Friday" teaches how to calculate the date which will be the third Friday of any month (and by extension the 1st, 2nd and Monday, Tuesday, etc.)
A Better Edit Undo
Access Macros
Activate And Select Methods Harmful
Applicability Of Structures
Applications Installing And Using An Application - MRUse Under Indxr Trail
Applications Maintain And Modify Macros
Applications VBA Consistency And VBE Inconsistency
Applications What They Are Why They Are Important
Apply The Built-in Heading1 Paragraph Style
Arrays
Arrays In MS VBA
Assign A Word Macro To Keyboard
Assign A Word Macros To Macro Buttons
Assign The Enter Key To A Macro
Auditing Data in a GUI Form
Automatic Generation Of Keywords
Bar Chart From Table
Basic Programming Principles
Batch Find And Replace Operation On All Excel Workbooks
Built-in Dialogues
Calculate Third Friday
Change All Dates In A Document
Change Headers And Footers In A Document Protected For Forms
Change The System Cursor
Class Modules
Clear All Highlighting From A Document
Collections
Compound Macros
Convert To Table
Create A Numbered List Using Sequence Fields
Create Better Button Arrows
Cross Application Development
Current Region
Customizing the VBE Environment
Dealing With Strings
Debugging Excel VBA
Declaring Variables
Defining A Class Structure
Defining A Structure
Defining Complex And Compound Structures
Delete All Rows Of A Table That Contain A Particular Text String In The First Column
Delete Any Paragraph That Is An Exact Duplicate
Detect If The First Character In A Selection Is Alphanumeric
Detect Whether A Table Cell Is Empty
Determine The Index Number Of The Current Paragraph
Determine The Index Number Of The Current Table
Determine The Number Of Pages In A Document Using A VBA Command
Determine The Position Of The Cursor On The Page In Points
Determine Whether The Selection Is At The Start Of A Paragraph
Developer Tools
Display All Shapes On All Slides In A Presentation
Display All Shapes On A Slide
Display In A Message Box The Contents Of Each Cell In A Table Column
Document Variables
Drop Duplicates
Early And Late Binding
Early Binding
Early vs. Late Binding
Efficiency
Entering Passwords
Err Msg utility procedure
Excel Inline S U M
Excel VBA Libraries
Force The File New Dialog To Display In List View
Force The User To Save Documents Into A Particular Folder
Formatting Cells By Program Control
Forming An Intersection Of Two Ranges
Forming A Union Of Two Ranges
Functions Used in Excel Macros
Functions Used In Excel Worksheets
Functions Used In Excel Worksheets02
Functions Used In Word Macros
Functions What They Are Why They Are Important
Generating A Corporate Footer
Get Information On All The Drives On Your System
Getting Help
Going To Sleep
GUI Form To Accept Bookings
GUI Forms
GUI Forms Additional Controls
GUI Forms Building A Simple User Interface
GUI Forms What They Are Why They Are Important
Hide Text In Named Text Box On Slide
Hide Text Most recently Unhidden Text In Text Box
Highlight All Cells Containing Hyperlink
Highlight Any Misspelled Words
Highlight Misspelled Words
Importing To Excel From Text Files
Inhibit Interruptions
Intercept The GUI Close Button
Interrupt The Document close Event or Auto close Macro
Keep With Next
Launch Word From Excel
Libraries Fun4x
Libraries Hooking An INI File To A GUI Form
Libraries Use Of UW.dot
Libraries Use Of UX.xla
Libraries What They Are Why They Are Important
Library Development
Listing All Shapes In A Presentation
Loading Cells From A Novel Array
Locate A Named Shape Within A Presentation
Locating Strings
Loop Through Files In Folders
Macros In Word
Min Non Zero
Move Shape Anchors Away From Heading Paragraph
Much Ado About Nothing
Name A Textbox On A Slide
Named Ranges
Naming A Slide
New Sub Total
Objects
Objects Properties And Methods
Obtain A List Of Reserved Words
Obtain Cells Of A Workbook
Obtaining A Slides Index Number
Offsets
On Error
Opening The VBE
Parenting Orphaned Code
Parsing String File Data
Pattern Property
Powerful Engines Use of Indxr Dot
Powerful Engines What They Are Why They Are Important
PowerPoint VBA Automatic Creation Of Presentation Keywords
PowerPoint VBA Dynamic Colors
PowerPoint VBA Getting Started
PowerPoint VBA How To Create A Powerpoint97 Addin
PowerPoint VBA Locate And Highlight Instances Of A Specific Word
PowerPoint VBA Locate Specific Text And Format The Shape Containing It
PowerPoint VBA magic Color Changes
PowerPoint VBA Obtaining The Path And Name Of The Presentation
PowerPoint VBA Paste Special Not Available In PowerPoint Object Model
PowerPoint VBA Power Point Its Object Model
PowerPoint VBA Step Through All Elements Of A Presentation
PowerPoint VBA Text That Shrinks
PowerPoint VBA The PowerPoint Addin FAQ
PowerPoint VBA Useful PowerPoint VBA Code Snippets
PowerPoint VBA Using The Active presentation
PowerPoint VBA And The Clipboard
PowerPoint VBA When Were These Office Applications Ever Consistent
Prefaces A Cell Contents With Space
Preserve And Restore Session Settings
Prime A Budget Sheet With Date Dependant Values
Print All Documents In A Given Folder
Procedure Arguments
Procedures Function Subroutines And Macros
Processing All Cells In A Range By Column
Processing All Cells In A Range By Row
Processing Ranges Of Cells
Processing Sub strings
Public Sub Hello World
Putting Passwords On Excel Documents
Questions Answers
Range And Selections02
Range Property For Fields
Reading Data From A Text File
Reading Data Into A GUI Form
Rearrange A Row Of Cells Into A Column
Rebuild A Table
Regular Expressions
Release And Maintenance
Remove The Underline Attribute From Characters With Descenders
Replace Each Instance Of The Text String document One With The Contents Of A File Called Ctestdoc1doc.
Replace One Character With Another Wherever It Appears In A String
RVBA Naming Conventions
Save Print And Close A File
Scroll All Open Documents The Same Percentage As The Active Document
Select All But The First Two Cells In A Table Column
Select All Cells
Select All Rows Of A Table Except The First Row
Select A Named Text Box
Select The Current Region
Select The Used Range
Size The Text In A Textbox To Fill The Textbox
Sound Programming Practices
Speech Synthesis Of Text On Slides
Splitting Strings
Spreadsheet Controls
Stacks
Storing Data From A GUI Form
Structures And Dictionaries
Testing User Response
Text That Shrinks
The Excel Spreadsheet Model
The Paste Special Command
The VBE Environment
Toolbar Keyboard And Menu Macros
Training Fees VBA
Tree Control
Unhide Most Recently Hidden Text In Text Box
Unhide Text In Named Text Box On Slide
Union And Intersection
User Assisted Ranges
User Interface
Using Structures
Utility Functions
VBA Code Optimization
VBA Code To Jump To A Named Slide
VBE Development Techniques
VBE Shortcut Keys
VBE Short Cuts
VBE Tips'n'tricks
Visit Successive Tables In A Document
Wilson Jones Folder Layouts
Word Edit Access Data
Word Process Access Data
Word Transpose A Table Via Excel
Loading
Toronto and Mississauga, Monday, March 21, 2011 9:03 AM
Copyright © 1996-2011 Chris Greaves. All Rights Reserved.