RyanDev.com

Here are some quick and easy to use tutorials if you are interested in learning VBA.  Please let me know if there are other topics you would like me to cover.  There are 6 modules and each has a series of attachments to download the full documentation and code samples.  Below are summaries of what each module covers.

Module 1

Introduction

The purpose of this module is to familiarize you with the Visual Basic Editor environment and to introduce some coding techniques. By the end of this module you should be able to accomplish the following tasks:

• Arrange and navigate the Visual Basic Editor
• Write and edit macros
• Write code to respond to events
• Recognize and have a basic understanding of the Object Model

Attachments: Module 1.doc

Module 2

Introduction

The purpose of this module is to introduce automation of Microsoft Office products. By the end of this module you should be able to accomplish the following tasks:

• Automate one Office product from within a different Office product
• Understand how to reference the Object Model of different Office products
• Use debugging techniques
• Implement error handling

Attachments: Module 2.doc; DataFile.xls

Module 3

Introduction

The purpose of this module is to allow you to put in practice lessons from Modules 1 and 2. Each of the examples listed here come from real calls that I have had. By the end of this module you should be able to accomplish the following tasks:

• Write custom functions in Microsoft Excel
• Play a sound in Excel when a cell changes
• Format cells in a Word table

Attachments: Module 3.doc; Count Criteria.xls

Module 4

Introduction

The purpose of this module is to introduce user forms that can be used in VBA. By the end of this module you should be able to accomplish the following tasks:

• Create a user form in Excel.
• Create a user from in Word to pull data from Access.

Attachments: Module 4.doc; Count Formulas.xls; Addresses.mdb

Module 5

Introduction

The purpose of this module is to introduce VBA programming with Microsoft Access. By the end of this module you should be able to accomplish the following tasks:

• Create a new Microsoft Access database from within Excel.

Attachments: Module 5.doc; Addresses.mdb

Module 6

Introduction

The purpose of this module is to introduce VBA in Microsoft Outlook and Microsoft PowerPoint. By the end of this module you should be able to accomplish the following tasks:

• Create a user form in Excel.
• Create a user from in Word to pull data from Access.

Attachments: Module 6.doc; Addresses.mdb

Below is some sample code that I have used in the past that has some useful date and time functions.  The code was written in Visual Basic 6.0 but can easily be converted to .Net.

Public Function LastDayOfMonth(ByVal ADate As Date, PreviousMonth As Integer) As Integer ‘Previous month is an offset of the passed in date to return the last day in a different month