VBA Lesson 11: VBA Code General Tips and General Vocabulary Speed Up Efficient VBA Code/MacrosĮxcel VBA Performance Coding Best Practices - Office BlogsĬreating An XLA Add-In For Excel, Writing User Defined Functions In VBA Here are some general links on performance improvement: TechBookReport - Debugging Excel VBA Code How do I create and use a PERSONAL file for my VBA codeĪnthony's Excel VBA Page - Excel Application - Excel Consultant - Excel Consulting (see 3 tutorials in Excel VBA Basic Tutorial Series) Ron de Bruin's Mail from Excel and make/mail PDF files (Windows) There's a chapter on classes in VBA Developer's Handbook which is also good. Here is a good introductory tutorial using a VBA Class:

What is a VBA Module and How is a VBA Module Used? See David McRitchie's site if you just started with VBA Variable Scope in Excel VBA - EASY Excel Macros Here's a good primer on the scope of variables. Introduction to Variables, Constants and Data Types The macro recorder actually is your friend but look here: How to insert and run VBA code in Excel - tutorial for beginners Difference between OLEFormat and ControlFormat?įor references purposes and excellent explanations, seeĮxcel VBA MACRO Kick-start Course for absolute beginner If you are serious about learning VBA tryĮxcel Tutorials and Tips - VBA - macros - training There are over 1800 Excel videos/tutorials here: MrExcel's Products: Books, CDs, Podcasts Discuss topics related to Holy Macro! Products: Learn Excel from MrExcel, VBA and Macros for Microsoft Excel,Holy Macro! It's 2500 VBA Examples CD, Guerilla Data Analysis Using Microsoft Excel and Excel Knowledge Base CD and the MrExcel Podcasts. There are some good videos at DataPigTechnologies as well. Generally the best way to learn is to use it on a live project, but otherwise have a look through this list kindly provided by Hiker95.

Visual basic macro excel tutorial