FunctionX FunctionX Press Microsoft Excel MS Access SQL Server Visual C# ASP.NET (C#) C++ Builder Visual C++/CLI
VBA for Microsoft Office Excel 2007
 

Microsoft Excel is a computer application used to create and managed spreadsheets. With Microsoft Office Excel 2007, new features were added to the application, including the Ribbon and other objects.

To implement functionality beyond a regular spreadsheet, a Microsoft Visual Basic programming environment is installed with Microsoft Office Excel 2007. The computer language used is Visual Basic for Application (VBA).

In the lessons on this site, we learn how to use Microsoft Excel to create electronic spreadsheets. When necessary, we also use VBA code to enhance the spreadsheets using Windows controls (design and programming).

 
 

Table of Contents

Introduction to MS Excel
Introduction to VBA
Variables and Data Types
Operators and Operands
Introduction to Procedures
Introduction to Objects
The Properties Window
Introduction to Forms
Introduction to Controls
Form and Controls Design
Messages and Events
Objects and Collections
Workbooks
Worksheets
The Columns on a Worksheet
The Rows of a Worksheet
The Cells on a Worksheet
Cells Aesthetic Formatting
Introduction to Built-In Functions
Strings
Introduction to Conditions
Introduction to Conditional Statements
Functional Conditions
Conditional Selections
Logical Conjunction and Disjunction
Error Handling
File Processing
 
 
 
 

Fundamental Topics

VBA Excel Fundamental Spreadsheet Objects
 

VBA Excel Fundamental Spreadsheet Objects

Fundamental Topics  
 

Cells

Cells
 

Procedures and Functions

Procedures and Functions
 

Topics

Topics
  •  
 
 

Example Applications

VBA Excel Fundamental Spreadsheet Objects
College Park Auto Repair

This application was created to illustrate the ability to automatically save or open a workbook

 
 
Documents The previous version of this web site
 

 

 

Form and Control Design

 

Conditional Statements

 

Keywords

 

Expressions

 
 
 
 
C# Key Win32 MS Excel MS Access ADO Object Pascal C++/CLI ASP.NET SQL JavaScript
Yevol.com Visual Basic StarCalc VBA For MS Access C# Delphi C++ Builder MS PowerPoint HTML VBScript
 

Contact Mirror Site Published on Sunday 21 September 2008 Copyright © 2004-2011 FunctionX, Inc.