Learning Visual Basic for Microsoft Excel

About The Author

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

The Working Files Explained

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

What Is VBA?

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

The Developer Ribbon

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

The New Macro Enabled File Type

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

Watch A Macro Write Your VBA

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

03. Procedures And Functions

What Is A Module?

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

How To Call A Sub Procedure

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

Creating A Function Procedure

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

How To Call A Function

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

04. Getting Started With VBA Programming

The Scope Of A Variable

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

Constants Instead Of Variables

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

An Intrinsic Constant

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

String And Date Types Expanded

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

VBA Operators

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

Arrays

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

Multi-Dimensional Arrays

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

Dynamic Arrays

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

05. Manipulating Excel Objects

The CELLS Property

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

The OFFSET Property

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

The VALUE Of Ranges

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

The TEXT Object Of The RANGE

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

The FONT Property And Colors

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

Formatting Numeric Values

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

06. Working With Excel VBA Functions

What Is A Function?

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

Built In VBA Date Functions

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

User Defined Functions

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

07. Controlling Program Flow And Execution

Using GOTO And Labels

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

The FOR NEXT Loop

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

FOR NEXT With A VBA Collection

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

DO WHILE Loop

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

How To Create An Event

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

WorkBook Events - Open

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

Other Useful Worksheet Triggers

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

Using Application Events

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

09. Debugging And Error Handling

Error Trapping the Easy Way

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

Make The VBA Ignore Errors

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

Making Use Of The ERR Object

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

Debugging Techniques

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

Using Breakpoints To Help Debug

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

Setup And Use A Watch

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

Speeding Up The VBA Tips

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

10. Interacting With Users Through Forms

An Introduction To UserForms

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

Creating A UserForm

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

Using Command Buttons

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

Adding Option Buttons In A Frame

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

UserForm Controls - The CheckBox

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

Images On UserForms

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

Labels And Text Boxes

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

Multiple Tabs On A UserForm

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

Scrollbar And Spin Controls

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

11. Running And Storing VBA Code

Customizing The Ribbons

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

Adding Buttons To Sheets

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

Where To Store Your VBA Code

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

Adding Code To The PERSONAL File

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

So What's Next?

Closed Captioning:?Unavailable

Mobile-Friendly Format:?Available on m.safaribooksonline.com

Example Files:?Available on Extras tab

let it snow jason trawick jerry lewis tampa bay bucs cowboys cowboys slim dunkin