Microsoft Excel VBA programming for the absolute beginner
نام عام مواد
[Book]
نام نخستين پديدآور
Duane Birnbaum.
وضعیت ویراست
وضعيت ويراست
2nd ed
وضعیت نشر و پخش و غیره
محل نشرو پخش و غیره
Boston, Mass.
نام ناشر، پخش کننده و غيره
Thomson Course Technology
تاریخ نشرو بخش و غیره
2005
مشخصات ظاهری
نام خاص و کميت اثر
(xii, 489 pages) : illustrations
فروست
عنوان فروست
For the absolute beginner (Series)
يادداشت کلی
متن يادداشت
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 --; 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.
رده بندی کنگره
شماره رده
HF5548
.
4
.
M523
نشانه اثر
D836
2005
نام شخص به منزله سر شناسه - (مسئولیت معنوی درجه اول )