Visual Basic (VB) Guide

Visual Basic Logo Visual Basic, or VB, is a programming language created by Microsoft. Visual Basic is derived from the BASIC programming language, which was designed to be easy to learn and use. It has been extended by Visual Basic.NET, or VB.NET, which runs on the .NET platform. Visual Basic applications can be created using the Microsoft Visual Studio IDE, with a free version available called Visual Studio Express.

Visual Basic for Applications, or VBA, is used to create macros in a number of applications such as Microsoft Office, allowing you to automate a number of tasks.

This guide will show you some examples of what is possible with Visual Basic and Visual Basic for Applications.

VBA Examples This article shows readers how to apply Visual Basic for Applications (VBA) to automate and extend Microsoft Excel and Word....	Add Field Codes to Footers in MS Word This article teaches readers how to add field codes to footers in MS Word documents. That task enables Word users to apply field codes to paginate their documents and enable other automatically...
Office VBA Examples This article shows readers how to use Visual Basic for Applications to link database tables, create time-saving field codes, create a custom function in Excel, and much more....	Accessing MS Word Fields in Visual Basic for Applications This article shows readers how to use VBA to insert, navigate to, and delete field codes in Word....

Getting Started with Microsoft Excel Visual Basic for Applications (VBA)

It is nice to know that you can create code in your office suite to automate some repetitive tasks, but it may seem frightening to those who haven't tried before. No worries, here we explain Excel...

Updating Microsoft Excel Macros for 2010

Converting macros for Excel 2010 from 2003 isn't particularly hard and this guide will show you how....

MS Access 2007: Calculating Mean, Median and Mode

MS Access has built-in mathematical functions to crunch numbers. For statistical data, however, the only handy function is the mean (average). Calculating median and mode, however, requires Visual...

How to Use a Macro to Find Duplicates in MS Excel

If you keep an extensive range of data in Excel spreadsheets you've probably come across occasions when you need to root our duplicate data. Depending on your version of Excel you can uncover duplicates...

Everything You Need to Know about Microsoft Excel Formulas and Functions

In this article, I will explain everything you need to know about Microsoft Excel Formulas and Functions. After reading this tutorial, you will be well on your way to becoming a Excel Ninja....

Getting Started with Microsoft Excel Visual Basic for Applications (VBA)

It is nice to know that you can create code in your office suite to automate some repetitive tasks, but it may seem frightening to those who haven't tried before. No worries, here...

Excel VBA Examples

This article trains readers in the fundamentals of automating Excel with Visual Basic for Applications....