Apache Hive      |     Cognos      |     Data Mining       |     DRM      |     DataWarehouse, Data Modeling and ETL      |     Erwin      |     Essbase      |     FDM      |     Hadoop      |     HFM      |     Hyperion Planning      |           |     Informatica      |     Java      |     MapReduce      |     Microstrategy      |     MYSQL-PHP      |     OBIEE      |     Oracle EBS      |     Peoplesoft      |     PLSQL      |     MS Project      |     SAP      |     SQL      |     SQL Server      |     Tableau      |     Template      |     TeraData      |     Toad      |     Unix      |     Visio      |     XML

Index of VBA topics | Visual Basic for Applications

A Simple Literature Database
Access to the Clipboard with the DataObject
Actions with Methods
Add Methods
Analysis of Complex Tables
Application of the Object Classes
Built-in Functions
Code Input in Modules
Collection Object
Common Members
Compare Bits
Configuration Files, Custom Configuration
Control Structures
Control Structures
Control the Compiler
Copying, Cutting, and Pasting Ranges of Cells
Create Properties
Creating Applications using Excel
Data Transfer via the Clipboard
Database Worksheet Functions
Date and Time Functions
Debugging, Protection When Errors Arise
Declaring a Procedure
Define Enumerations
Deleting a Sheet
Determining the Address of a Range of Cells
Dimensioning Fields
Do Math
Driving Excel from Other Office Programs
Driving Microsoft Outlook
Error Checking
Error-Tolerant Behavior of Programs
Event procedures
Excel 2007 VBA Macro Programming
Excel 2007 VBA Programmers Reference
Excel Meets the Euro
Executing Macros
Find the Right Object
Find Truth
Formulating and Evaluating Logical Conditionals
Get Dates and Times
Get Excel Objects
Global and Static Variables
Highlights of the Menu System
History of VBA
If Then statement
Introduction To VBA
Introduction to VBA.ppt
Jumping from the First to the Last Sheet of a List
Keyboard Shortcuts
Linking a Custom Style with a Tool
Linking and Inserting Data
Macro to save the document as html format with title
Macro for Simplifying Input
Macros and Security
Macros VBA Basics
Matrix Functions
Naming Conventions
Obtaining File Names and Opening Workbooks
On-line VBA Help
Operation Risk Management using Excel and VBA
Operators in VBA
Payment Function
Placing Controls Directly into Worksheets
Pro Excel 2007 VBA
Procedural Programming
Programming Excel With VBA and .NET
Programming Matrix Functions
Programming Techniques
Programming Your Own Classes
Properties and Methods Explained
Protection Mechanisms
Quick tutorial on VBA using Excel.doc
Raise Events
Read and Write Files
Recording a Macro
Recording Macros
Response to Program Interrupts
Rounding Numbers
Run Other Applications
Select Case
Setting Options with Program Code
Splitting Windows at the Current Position of the Cell Pointer
Strings and Functions and Message Boxes
Subs vs. Functions
Syntax Summary
Techniques of Programming
Text Files
The Concept of Objects
The Err Object
The Errors Collection
The Excel Object Hierarchy
The Global Object
The Option Base Statement
The VBA Model
The VBE Library
The WorksheetFunction Object
Tips and Tricks
Tools for Debugging Code
Transformation Functions
Transforming Windows into Icons
Turning Gridlines and Cell Headings On and Off
Understanding a Database Application
User-Defined Forms
User-Defined Functions
User-Defined Worksheet Functions
Using Excel to Interact with Other Office Programs
Using Procedures to Change a Database Structure
Value and Return Parameters
Variable Declaration
VBA Computer Programming Concepts and Visual Basic
VBA Concepts
VBA Data Types
VBA for Excel Made Simple
VBA Functions
VBA Issues in Excel 2007
VBA Procedures
VBA Programming Essentials
VBA Programming.ppt
View Results
Virus Protection
Visual Basic for Applications (VBA).ppt
What Is Visual Basic for Applications
Work with Text
Workbook Object
Workbooks, Windows, and Worksheets
Working with Dates and Times
Working with Files; Text Import and Export
Working with Numbers and Character Strings
Working with Objects, Methods, and Properties
Working Without VBA
Writing Your First Macro