Microsoft Excel VBA programming for the absolute beginner [electronic resource] / Duane Birnbaum.
Material type: TextSeries: For the absolute beginner (Series)Publication details: Indianapolis, IN : Premier Press, 2002.Description: 1 online resource (xii, 412 p.) : illISBN:- 0585439850 (electronic bk.)
- 9780585439853 (electronic bk.)
- 005.133 21
- HF5548.4.M523 B572 2002eb
Includes index.
Visual Basic for Applications with Excel -- Project: Colorful Stats -- Installing and Enabling VBA -- The VBA Integrated Development Environment (IDE) -- Getting to the IDE from Excel -- Components of the IDE -- Programming Components within Excel -- Macro Selection -- The Visual Basic Toolbar -- Getting Help with VBA -- VBA Help -- Constructing the Colorful Stats Program -- Requirements of the Colorful Stats Program -- Beginning Programs with VBA -- Project: Biorhythms and the Time of Your Life -- Variables, Data Types, and Constants -- Declaring Variables -- Data Types -- Constants -- Simple Input and Output with VBA -- Collecting User Input with InputBox() -- Output with MsgBox() -- Manipulating Strings with VBA Functions -- Fun with Strings -- Constructing the Biorhythms and the Time of Your Life Program -- Requirements for Biorhythms and the Time of Your Life -- Designing Biorhythms and the Time of Your Life -- Coding Biorhythms and the Time of Your Life -- Procedures and Conditions -- Project: Poker Dice -- VBA Procedures -- Event Procedures -- Private, Public, and Procedure Scope -- Sub Procedures -- Function Procedures -- Logical Operators with VBA -- Conditionals and Branching -- Constructing the Poker Dice Program -- Requirements for Poker Dice -- Designing Poker Dice -- Coding Poker Dice -- Loops and Arrays -- Project: Math Game -- Looping with VBA -- Do Loops -- For Loops -- Input Validation -- Validation with the InputBox() Function -- Validation with a Spreadsheet Cell -- Arrays -- One-Dimensional Arrays.
Description based on print version record.
There are no comments on this title.