Sponsored Links

 

 

 

An Introduction to VBA in Excel

Source: www.math.vu.nl
Topic: Microsoft Office


Short Desciption:
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 ...

 

Content Inside:
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 Copyright c 1995-2000 Robert L. McDonald. Thanks to Jim Dana for asking stimulating 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 write numbers from the spreadsheet 11 5.2 Reading and Writing to Cells Which are not Named. . 12 5.3 Using the Cells Function to Read and Write to Cells 13 6 Using Excel Functions 13 6.1 Using VBA to compute the Black-Scholes formula 13 6.2 The Object Browser . 15 7 Checking for Conditions 16 8 Arrays 17 8.1 Defining Arrays 18 9 Iterating 19 9.1 A simple for loop . 20 9.2 Creating a binomial tree . 20 9.3 Other kinds of loops . 22 10 Reading and Writing Arrays 22 10.1 Arrays as Output . 23 10.2 Arrays as Inputs . 24 10.2.1 The Array as a Collection . . 24 10.2.2 The Array as an Array . . 25 11 Miscellany 26 11.1 Getting Excel to generate your macros for you 26 11.2 Using multiple modules . 27 11.3 Recalculation speed . 27 11.4 Debugging . 28 11.5 Creating an Add-in . . 28 12 A Simulation Example 29 12.1 What is the algorithm? . 29 12.2 VBA code for this example 30 12.3 A trick to speed up the calculations 32 Copyright c 1995-2000, Robert L. McDonald. November 3, 2000 2 ...

 

add to Google Reader add to Google Bookmark add to bloglines add to newsgator add to FURL add to digg add to webnews add to Netscape add to Yahoo MyWeb add to spurl.net add to diigo Bookmark newsvine Bookmark del.icio.us Bookmark @ SIMPIFY Bookmark MISTER WONG Bookmark Linkarena Bookmark icio.de Bookmark oneview Bookmark folkd.com Bookmark yigg.de Bookmark reddit Bookmark StumbleUpon Bookmark Slashdot Bookmark blinklist Bookmark technorati add to blogmarks add to blinkbits add to ma.gnolia add to smarking.com add to netvouz add to co.mments add to Connotea add to de.lirio.us

 

Related PDF Files

Microsoft Office Specialist Improving the Workplace


Topic: Microsoft Office

Office Specialist certifications in Microsoft Word, Excel, PowerPoint®, Access, Outlook®, and/or Project improve the workplace not only for employees and their employers but also for their customers. ...

Using Microsoft® Office Excel® 2007 Exam Guide


Topic: Microsoft Office

Using Microsoft® Office Excel® 2007 Exam Guide Preparation Recommendations Step 1: Assess your skills: Prepare for the Using Microsoft Excel 2007 Application Specialist certification exam by taking ...

Using Microsoft® Office PowerPoint® Exam Guide


Topic: Microsoft Office

Using Microsoft® Office PowerPoint® Exam Guide Preparation Recommendations Step 1: Assess your skills: Prepare for the Using Microsoft Office PowerPoint 2007 Application Specialist certification ...

Developer Map for the 2007 Microsoft® Office system


Topic: Microsoft Office

... Installable form templates • Managed-code object model • Outlook e-mail integration • Template parts • Microsoft ® Visual Studio ® Tools for Applications Microsoft.Office.Core Microsoft.Office ...

Microsoft Office Access 2 Day Introduction Course


Topic: Microsoft Office

ashbee Computer Services Tel: 01483 810500 Email: enquiries@ashbee.co.uk Website: www.ashbee.co.uk Microsoft Office Access 2 Day Introduction Course Please find listed below the topics included in our ...

 

Sponsored Links