Everyone is looking for ways to save money these days. That can be hard to do for businesses that have complex needs, such as custom software applications. However, VBA and Macros for Microsoft Excel can teach you ways to customize pre-existing software to meet your specific needs. A variety of topics are covered that are sure to give you a solid knowledge of the VBA language. Event programming, user forms, carts, pivot tables, multi-dimensional arrays and Web queries are just a few of the areas you will learn about in this book. Written by the principal behind the leading Excel Web site, www.mrexcel.com, this book is sure to save you time and money!
Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.
Descrizione libro Que Publishing, 2004. Condizione libro: New. Brand New, Unread Copy in Perfect Condition. A+ Customer Service! Summary: Introduction.Getting Results with VBA.What Is in This Book.A Brief History of Spreadsheets and Macros.The Future of VBA and Excel.Special Elements and Typographical Conventions.Next Steps.I. FIRST STEPS UP THE VBA LEARNING CURVE.1. Unleash the Power of Excel with VBA!The Power of Excel.Barriers to Entry.Knowing Your Tools-The Visual Basic Toolbar.Macro Security.Overview of Recording, Storing, and Running a Macro.Running a Macro.Understanding the Visual Basic Editor (VBE).Examining Code in the Programming Window.Running the Macro on Another Day Produces Undesired Results.Frustration.Next Steps: Learning VBA Is the Solution.2. This Sounds Like BASIC, So Why Doesn't It Look Familiar?I Can't Understand This Code. Understanding the Parts of VBA "Speech". Is VBA Really This Hard? No! Examining Recorded Macro Code-Using the VB Editor and Help. Using Debugging Tools to Figure Out Recorded Code. The Ultimate Reference to All Objects, Methods, Properties. Five Easy Tips for Cleaning Up Recorded Code. Putting It All Together-Fixing the Recorded Code. Next Steps.3. Referring to Ranges.The Range Object. Using the Top-Left and Bottom-Right Corners of a Selection to Specify a Range. Referencing Ranges in Other Sheets. Referencing a Range Relative to Another Range. Using the Cells Property to Select a Range. Using the Offset Property to Refer to a Range. Using the Resize Property to Change the Size of a Range. Using the Columns and Rows Properties to Specify a Range. Using the Union Method to Join Multiple Ranges. Using the Intersect Method to Create a New Range from Overlapping Ranges. Using the IsEmpty Function to Check Whether a Cell Is Empty. Using the CurrentRegion Property to Quickly Select a Data Range. Using the Areas Collection to Return a Non-contiguous Range. Next Steps.4. User-Defined Functions.Creating User-Defined Functions. Useful Custom Excel Functions. Next Steps.5. Looping.For.Next Loops. Do Loops. The VBA Loop: For Each. Next Steps.6. R1C1 Style Formulas.Referring to Cells: A1 Versus R1C1 References.Switching Excel to Display R1C1 Style References.The Miracle of Excel Formulas.Explanation of R1C1 Reference Style.Conditional Formatting-R1C1 Required.Array Formulas Require ConditionalFormatting. Next Steps.7. Names.Global Versus Local Names.Adding Names.Deleting Names.Types of Names.Hiding Names.Checking for the Existence of a Name.Next Steps.8. Event Programming.Levels of Events.Using Events.Workbook Events.Worksheet Events.Chart SheetEvents.Application-Level Events.Next Steps.9. UserForms-An Introduction.User Interaction Methods.Creating a Userform.Calling and Hiding a Userform.Using Basic Form Controls.Using the Multipage Control to Combine Forms.Next Steps.II. AUTOMATING EXCEL POWER IN VBA.10. Charts.Overview.Embedded Charts Versus ChartSheets.Creating a Chart with VBA.Using Object Variables to Streamline Code.The Anatomy of a Chart.Table of Chart Types.Details of Various Chart Types.Interactive Charts.Exporting Charts as Images.Drawing with X-Y Charts.Custom Charts with VBA.Next Steps.11. Data Mining with Advanced Filter.Advanced Filter Is Easier in VBA Than in Excel.Using Advanced Filter to Extract a Unique List of Values.Using Advanced. Codice libro della libreria ABE_book_new_0789731290
Descrizione libro Que Publishing, 2004. Paperback. Condizione libro: New. book. Codice libro della libreria 0789731290
Descrizione libro Que Publishing, 2004. Paperback. Condizione libro: New. Codice libro della libreria P110789731290
Descrizione libro Condizione libro: Brand New. Book Condition: Brand New. Codice libro della libreria 97807897312961.0
Descrizione libro Que Publishing, 2004. Paperback. Condizione libro: New. 1. Codice libro della libreria DADAX0789731290
Descrizione libro QUE, 2004. Paperback. Condizione libro: Brand New. 1st edition. 576 pages. 9.00x7.25x1.25 inches. In Stock. Codice libro della libreria zk0789731290
Descrizione libro Que Publishing. PAPERBACK. Condizione libro: New. 0789731290 New Condition. Codice libro della libreria NEW4.0437123