Transcription of Chapter 1 - VBA
{{id}} {{{paragraph}}}
MINE 325 Mine Planning and Design VBA Compiled by: Hooman Askari Chapter 1-1 Chapter 1 - VBA introduction .. 1-2 Visual Basic for Applications with Excel .. 1-2 The VBA Integrated Development Environment (IDE) .. 1-2 Programming Components within Excel .. 1-5 Getting Help with VBA .. 1-9 Constructing the Colorful Stats Program .. 1-10 Beginning Programs with VBA .. 1-13 Variables, Data Types, and Constants .. 1-13 Simple Input and Output with VBA .. 1-21 Procedures and Conditions .. 1-23 VBA Procedures .. 1-24 Manipulating Strings with VBA Functions.
1.2.2.1 Macro Selection Now that you've had an introduction to the VBA IDE, it's time to look at development tools accessed directly from Excel. To begin, take a closer look at the Macro selection from the Tools menu, shown in Figure 1.1. Notice two other items displayed in Figure 1.1 that I have not yet discussed: Macros and Record New Macro.
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}