Microsoft Excel VBA Programming for the Absolute Beginner
If you are new to programming with Microsoft Excel VBA and are looking for a solid introduction, this is the book for you. Developed by computer science professors, books in the "for the absolute beginner" series teach the principles of programming through simple game creation. Microsoft Excel VBA Programming for the Absolute Beginner, Third Edition provides you with the skills that you need for more practical Excel VBA programming applications and shows you how to put these skills to use in...
Search in google:
This introduction to Excel VBA uses simple game creation to explain the principles of programming. It details the program components and provides instruction on adding multimedia and intelligence, customizing menus and toolbars, querying external data sources, and creating and manipulating chart objects and shape objects. A companion CD contains all source code from the book, two bonus chapters, links to related Web sites, graphics and sound tools, and sample VBA programs. Annotation (c)2003 Book News, Inc., Portland, OR
IntroductionxChapter 1Visual Basic for Applications with Excel1Project: Colorful Header2The VBA Integrated Development Environment (IDE)3Getting to the IDE from Excel3Components of the IDE4Programming Components within Excel8Macro Selection8The Visual Basic Toolbar9Getting Help with VBA13Excel Help14VBA Help14Installing VBA Help Files15Constructing the Colorful Header Program15Chapter Summary19Chapter 2Beginning Programs with VBA21Project: Time of Your Life22Variables, Data Types, and Constants22Declaring Variables23Data Types27Constants36Simple Input and Output with VBA37Collecting User Input with InputBox()37Output with MsgBox()38Manipulating Strings with VBA Functions39Fun with Strings40Constructing the Time of Your Life Program44Project Statement44Project Tools44Project Algorithm44Adding the Code45Chapter Summary49Chapter 3Procedures and Conditions51Project: Poker Dice52VBA Procedures52Event Procedures52Sub Procedures56Function Procedures61Logical Operators in VBA64Conditionals and Branching67Constructing the Poker Dice Program72Project Statement73Project Tools73Project Algorithm75Adding the Code76Chapter Summary84Chapter 4Loops and Arrays87Project: The Math Game88Looping with VBA88Do Loops89For Loops91Input Validation94Validation with the InputBox() Function95Validation with a Spreadsheet Cell97Arrays99One-Dimensional Arrays101Multi-Dimensional Arrays104Dynamic Arrays106Programming Formulas into Worksheet Cells109A1 Style References109R1C1 Style References111Chapter Project: Math Game112Project Statement112Project Tools113Project Algorithm119Adding the Code122Chapter Summary131Chapter 5Basic Excel Objects133Project: Battlecell134VBA and OOP134Objects Defined135VBA Collection Objects137The Object Browser139Top-Level Excel Objects144The Application Object145The Workbook and Window Objects145The Worksheet Object153The Range Object154Working with Objects157Chapter Project: Battlecell161Project Statement161Project Tools162Project Algorithm162Adding the Code164Chapter Summary184Chapter 6Enhancing VBA Programs: Adding Multimedia and Intelligence187Project: Enhanced Battlecell188Adding Multimedia to a Program188Animation in VBA188Sound in VBA200Simulating Intelligence in Programs203Chapter Project: Enhanced Battlecell204Project Statement204Project Tools205Project Algorithm205Adding the Code208Chapter Summary224Chapter 7UserForms and Additional Controls227Project: Blackjack228UserForms228Adding a UserForm to a Project229Components of the UserForm Object229Adding ActiveX Controls to a UserForm231Showing and Hiding UserForms233Modal Forms233Custom Dialog Boxes with UserForms235Chapter Project: Blackjack246Project Statement247Project Tools247Project Algorithm247Adding the Code250Chapter Summary267Chapter 8Data Access, File I/O, Error Handling, and Debugging269Project: Word Find270File Input and Output (I/O)270Using VBA File I/O Methods271Error Handling283Using the On Error Statement283Debugging287Break Mode287The Immediate Window289The Watch Window290The Locals Window291Chapter Project: Word Find292Project Statement292Project Tools293Project Algorithm293Adding the Code296Chapter Summary310Chapter 9Excel Charts313Project: The Alienated Game314The Chart Object314Accessing Existing Charts314Manipulating Charts318Creating Charts322Chart Events326Chapter Project: The Alienated Game332Project Statement333Project Tools333Project Algorithm333Adding the Code335Chapter Summary355Chapter 10VBA Shapes357Project: Excetris358The Shapes Collection and Shape Objects358Manipulating a Shape Object360The ShapeRange Collection Object362Activating Shape Objects365The OLEObjects Collection366Chapter Project: Excetris368Project Statement369Project Tools369Project Algorithm370Adding the Code372Chapter Summary395A Final Word396Index397
![Microsoft Office Project 2007 Step by Step [With CDROM]](/application/data/covers/30/57/9780735623057.jpg "Microsoft Office Project 2007 Step by Step [With CDROM]")
