INTRODUCTION TO VISUAL BASIC FOR APPLICATIONS (VBA)

This tutorial introduces you to Visual Basic for Applications (VBA), a version of Visual Basics which comes with Microsoft Excel. You will learn how to type in and run a simple program in the form of a Function block.

Excel supplies ready-made functions such as log, exp, sin, cos, sum. In addition to these, you can define your own functions by writing Visual Basic modules. For example, suppose that you often have to calculate the area of a circle, 3.14159 r2. To avoid retyping this expression many times, you want to define a function called “Circ” that will automatically carry out that calculation.

First, you must open a Visual Basic module. Go into Excel and create a new workbook. Click on Tool / Macro / Visual Basic Editor. This opens the Visual Basic window. Note that there is a Shortcut Key to get to the Visual Basic editor, . The screen should look as below. Note the locations of the Code window, Project window and Properties window. The Code window will contain your programs. The Project Window lists the items associated with your spreadsheet; these fall into two main categories (folders): Excel objects (worksheets and workbook), and modules (or programs). For this course you will not need to pay attention to the Properties window. At the bottom of the screen is the Windows 95 or Windows NT taskbar, while at the top lie the usual menu and toolbars.

Get download pdf INTRODUCTION TO VISUAL BASIC FOR APPLICATIONS (VBA)

Related Tutorial

Filed Under Visual Basic 

Tags: , , , , , , , , , , , ,

Comments

Leave a Reply