An Introduction to VBA in Excel Vrije （介绍了Excel VBA的自由）.pdf

An Introduction to VBA in Excel ∗ Robert L. McDonald† First draft: November, 1995 November 3, 2000 Abstract This is a tutorial showing how to use the macro facility in Microsoft Office—Visual Basic for Applications—to simplify analytical tasks in Excel. Contents 1 Introduction 3 2 Calculations without VBA 3 3 How to Learn VBA 4 4 Calculations with VBA 5 4.1 Creating a simple function . . . . . . . . . . . . . . . . . . . . 5 4.2 A Simple Example of a Subroutine . . . . . . . . . . . . . . . 7 4.3 Creating a Button to Invoke a Subroutine . . . . . . . . . . . 7 4.4 Functions can call functions . . . . . . . . . . . . . . . . . . . 8 4.5 Illegal Function Names . . . . . . . . . . . . . . . . . . . . . . 9 4.6 Differences Between Functions and Subroutines . . . . . . . . 9 ∗ c Copyright 1995-2000 Robert L. McDonald. Thanks to Jim Dana for asking stimu- lating questions about VBA. †Finance Dept, Kellogg School, Northwestern University, 2001 Sheridan Rd., Evanston, IL 60208, tel: 847-491-8344, fax: 847-491-5719, E-mail: r-mcdonald@northwestern.edu. CONTENTS 2 5 Storing and Retrieving Variables in a Worksheet 10 5.1 Using a named range to read and