Recording and Running Macros in the Office Applications
Richard Mansfield
Abstract
Richard Mansfield
Abstract
This chapter explores the easiest way to get started with Visual Basic for Applications (VBA): recording simple macros using the Macro Recorder that's built into the Office applications. Then VB developers will see how to run their macros to perform useful tasks. The chapter helps them to learn how to record a macro, assign a macro to a button or keyboard shortcut, run a macro, and delete a macro. VBA is based on Visual Basic, a programming language derived from BASIC. BASIC, created in 1963, stands for Beginner's All-Purpose Symbolic Instruction Code. BASIC is designed to be user-friendly because it employs recognizable English words rather than the abstruse and incomprehensible programming terms found in languages like C. Visual Basic .NET (VB .NET) is just one version of Microsoft's long history of BASIC language implementations. Visual Basic Express is a free version of VB .NET.
A significance statement is not available in the OpenAlex record.
A contribution statement is not available in the OpenAlex record.
Method details are not available in the OpenAlex metadata.
Findings are not separately available in the OpenAlex metadata.
Limitations are not available in the OpenAlex metadata.
Application details are not available in the OpenAlex metadata.
This chapter explores the easiest way to get started with Visual Basic for Applications (VBA): recording simple macros using the Macro Recorder that's built into the Office applications. Then VB developers will see how to run their macros to perform useful tasks. The chapter helps them to learn how to record a macro, assign a macro to a button or keyboard shortcut, run a macro, and delete a macro. VBA is based on Visual Basic, a programming language derived from BASIC. BASIC, created in 1963, stands for Beginner's All-Purpose Symbolic Instruction Code. BASIC is designed to be user-friendly because it employs recognizable English words rather than the abstruse and incomprehensible programming terms found in languages like C. Visual Basic .NET (VB .NET) is just one version of Microsoft's long history of BASIC language implementations. Visual Basic Express is a free version of VB .NET.
Key concepts: Macro, Visual Basic for Applications, Visual Basic, Computer science, Programming language, Code (set theory), Simple (philosophy), Microsoft Visual Studio