عنوان

Microsoft Excel VBA programming for the absolute beginner

(Number (ISBN

1592007295

(Number (ISBN

1592007309

(Number (ISBN

9781592007295

(Number (ISBN

9781592007301

Number

b621093

Title Proper

Microsoft Excel VBA programming for the absolute beginner

General Material Designation

[Book]

First Statement of Responsibility

Duane Birnbaum.

Edition Statement

2nd ed

Place of Publication, Distribution, etc.

Boston, Mass.

Name of Publisher, Distributor, etc.

Thomson Course Technology

Date of Publication, Distribution, etc.

2005

Specific Material Designation and Extent of Item

(xii, 489 pages) : illustrations

Series Title

For the absolute beginner (Series)

Text of Note

Includes index.

Text of Note

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.

Business -- Computer programs.

Microsoft Excel (Computer file)

Microsoft Visual Basic for applications.

Class number

Book number

Duane Birnbaum.

Duane Birnbaum

Electronic name

[Book]

Y