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

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	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-2009 FunctionX, Inc.