VBA Basics

The UK's most regular instructor-led training courses.
Training information: excel course · Excel london

Resolved · Medium Priority · Version 2007

VBA Basics

Keith has attended:
Excel VBA course

by - delegate Keith [1 post] (2008 Apr 7 Mon, 10:34) Reply

Is there a good book that we should look at purchasing that will assist with the basics of development?

RE: VBA Basics

by - trainer Roy [16 posts] (2008 Apr 8 Tue, 11:24) Reply

Keith,
An excellent resource is John Walkenbach's site:
http://www.j-walk.com/ss/

Follow the link on the left to Excel Books.
Scroll down for the v2003 books.

Go for the 'Power Programming in VBA', not the 'Dummies' book.

I'd also strongly recommend the 2003 Formulas book. This covers use of names, various categories of built-in functions (e.g. financial), and also the strange and wonderful world of Array Formulas.

/Roy

· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Company Roles in Visual Basic Training

Please browse our web site to find out more about
excel course and other Microsoft training courses.

Vba tip:

Empty The Clipboard with CutCopyMode

After each Copy/Paste operation in VBA, you should use the following line of code to empty the clipboard. This ensures that the computer memory doesn't overload:

ActiveSheet.Paste
Application.CutCopyMode = False

View all VBA hints and tips