ScholarLens Back to search
2018•Unpublished venueRequires access

Introducing Visual Basic for Applications

Michael Alexander, Dick Kusleika, John Walkenbach

Open publisher page 2 citations

Abstract

This chapter introduces the Visual Basic for Applications (VBA) macro language that is a key component for users who want to customize and automate Excel. It teaches the user how to record macros and create simple macro procedures. A macro is a sequence of instructions that automates some aspect of Excel so that the user can work more efficiently and with fewer errors. A VBA macro is usually one of two types: a Sub or a Function. The chapter discusses the difference between the Sub and the Function. Excel provides two ways to create macros: turn on the macro recorder and record actions; and enter the code directly into a VBA module. The chapter describes each of the two ways to create macros. It provides an introduction to VBA programming, which is essential to write (rather than record) VBA macros.

About this research paper

What this paper is about

This chapter introduces the Visual Basic for Applications (VBA) macro language that is a key component for users who want to customize and automate Excel. It teaches the user how to record macros and create simple macro procedures. A macro is a sequence of instructions that automates some aspect of Excel so that the user can work more efficiently and with fewer errors. A VBA macro is usually one of two types: a Sub or a Function. The chapter discusses the difference between the Sub and the Function. Excel provides two ways to create macros: turn on the macro recorder and record actions; and enter the code directly into a VBA module. The chapter describes each of the two ways to create macros. It provides an introduction to VBA programming, which is essential to write (rather than record) VBA macros.

Why it matters

OpenAlex reports 2 citations for this work. Citation counts describe recorded attention and do not establish research quality.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

This chapter introduces the Visual Basic for Applications (VBA) macro language that is a key component for users who want to customize and automate Excel. It teaches the user how to record macros and create simple macro procedures. A macro is a sequence of instructions that automates some aspect of Excel so that the user can work more efficiently and with fewer errors. A VBA macro is usually one of two types: a Sub or a Function. The chapter discusses the difference between the Sub and the Function. Excel provides two ways to create macros: turn on the macro recorder and record actions; and enter the code directly into a VBA module. The chapter describes each of the two ways to create macros. It provides an introduction to VBA programming, which is essential to write (rather than record) VBA macros.

Key concepts: Visual Basic for Applications, Macro, Computer science, Visual Basic, Function (biology), Programming language, Code (set theory), Key (lock)

Related papers

Related paper 1Related paper 2Related paper 3
Back to paper searchBrowse research topicsOriginal source
Introducing Visual Basic for Applications — Research Paper | ScholarLens