| Document Type
|
:
|
BL
|
| Record Number
|
:
|
801030
|
| Doc. No
|
:
|
b621093
|
| Main Entry
|
:
|
Duane Birnbaum.
|
| Title & Author
|
:
|
Microsoft Excel VBA programming for the absolute beginner\ Duane Birnbaum.
|
| Edition Statement
|
:
|
2nd ed
|
| Publication Statement
|
:
|
Boston, Mass.: Thomson Course Technology, 2005
|
| Series Statement
|
:
|
For the absolute beginner (Series)
|
| Page. NO
|
:
|
(xii, 489 pages) : illustrations
|
| ISBN
|
:
|
1592007295
|
|
|
:
|
: 1592007309
|
|
|
:
|
: 9781592007295
|
|
|
:
|
: 9781592007301
|
| Notes
|
:
|
Includes index.
|
| Contents
|
:
|
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 --; Multi-Dimensional Arrays --; Dynamic Arrays --; Programming Formulas into Worksheet Cells --; A1 Style References --; R1C1-Style References --; Constructing the Math Game --; Requirements for the Math Game --; Designing the Math Game --; Coding the Math Game Program --; Basic Excel Objects --; Project: Battlecell --; VBA and Object-Oriented Programming --; Objects Defined --; VBA Collection Objects --; The Object Browser --; Top-Level Excel Objects --; The Application Object --; The Workbook and Window Objects --; The Worksheet Object --; The Range Object --; Working with Objects --; Constructing Battlecell --; Requirements for Battlecell --; Designing Battlecell --; Coding Battlecell --; VBA UserForms and Additional Controls --; Project: Blackjack --; Designing Forms with VBA --; Adding a Form to a Project --; Components of the UserForm Object --; Adding ActiveX Controls to a Form --; Showing and Hiding Forms --; Modal Forms --; Designing Custom Dialog Boxes Using Forms --; Derived Data Types in VBA --; Defining Custom Data Types in VBA --; Defining Enumerated Types in VBA --; Chapter Project: Blackjack --; Requirements for Blackjack --; Designing Blackjack --; Writing the Code for Blackjack --; Error Handling, Debugging, and Basic File I/O --; Project: Word Find --; Error Handling --; Using the On Error Statement --; Debugging --; Break Mode --; The Immediate Window --; The Watch Window --; The Locals Window --; File Input and Output (I/O) --; File I/O Using Workbook and Worksheet Objects --; Using VBA File I/O Methods --; Chapter Project: Word Find --; Requirements for Word Find --; Designing Word Find --; Writing the Code for Word Find --; Using XML with Excel-VBA Projects --; Project: Revisiting the Math Game --; Introduction to XML --; What Is XML? --; XML Syntax --; XML Schemas --; XML Validation --; XML and Excel --; XML and VBA --; The XmlMap Object --; Chapter Project: The Math Game --; Requirements for the Math Game Program --; Designing the Math Game --; Coding the Math Game Program --; Excel Charts --; Project: The Alienated Game --; The Chart Object --; Accessing Existing Charts --; Manipulating Charts --; Creating Charts --; Chart Events --; Chapter Project: The Alienated Game --; Requirements for the Alienated Game --; Designing the Alienated Game --; Coding the Alienated Game --; VBA Shapes --; Project: Excetris --; The Shapes Collection and Shape Objects --; Manipulating a Shape Object --; The ShapeRange Collection Object --; Activating Shape Objects --; The OLEObjects Collection --; Chapter Project: Excetris --; Requirements for Excetris --; Designing Excetris --; Coding Excetris.
|
| Subject
|
:
|
Business -- Computer programs.
|
| Subject
|
:
|
Microsoft Excel (Computer file)
|
| Subject
|
:
|
Microsoft Visual Basic for applications.
|
| LC Classification
|
:
|
HF5548.4.M523D836 2005
|
| Added Entry
|
:
|
Duane Birnbaum
|