VBA For Microsoft Excel

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
	Introduction to Microsoft Excel Introduction to Macros and VBA Code Variables and Data Types Operators and Operands

VBA Excel Fundamental Spreadsheet Objects
	Workbooks Worksheets Worksheet's Columns	Rows of a Worksheet Cells of a Worksheet

Cells
	Introduction to Cells Cell Formatting Font Cell Content Alignment	Cells Borders Cells Background

Procedures and Functions
	Intro to Procedures Introduction to Functions	Arguments/Parameters A Review of Built-In Functions

Topics
	Strings Date and Time Values Comments

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

Exit Sub

C# Key	Win32	MS Excel	Microsoft 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-2016, FunctionX