Excel Vba Macro Programming


Excel Vba Macro Programming

  • 提携先の海外書籍取次会社に在庫がございます。通常2週間で発送いたします。
    1. 納期遅延や、ご入手不能となる場合が若干ございます。
    2. 複数冊ご注文の場合、分割発送となる場合がございます。
    3. 美品のご指定は承りかねます。
  • 【重要:入荷遅延について】

  • 製本 Paperback:紙装版/ペーパーバック版/ページ数 320 p.
  • 言語 ENG
  • 商品コード 9780072231441
  • DDC分類 005.268

Full Description

Publisher's Noteguaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Develop powerful, custom Excel applications using Visual Basic for ApplicationsMaximize the features and functionality of Excel with help from this unique resource designed specifically for power users. Inside, you'll find complete details on Excel VBA programming and application development--from the fundamentals to advanced techniques. Then, you'll get 21 real-world projects, complete with working code, so you can create Excel VBA macros right away. These projects include everything from setting up timed events to auto totaling a matrix of numbers to altering the appearance of spreadsheet components--and much more.Write and debug VBA codeCreate custom dialog boxes and toolbarsTake advantage of the Excel object modelWrite code to interact with a databaseUse application programming interface (API) callsCreate and use class modulesDevelop unique menus within the Excel menu structureExpand calculation and search functionsWrite macros for customized worksheetsCreate full-fledged Excel add-ins


Part IConstants, and Data Types 3: Modules, Functions, and Subroutines 4: Programming Basics: Decisions and Looping 5: Strings and Functions and Message Boxes 6: Operators 7: Debugging 8: Errors and the Error Function 9: Dialogs 10: Common Dialog Control 11: Command Bars and Buttons Part II: Object Models 12: The Excel Object Model 13: The Excel Object Model-Main Objects 14: Using Excel to Interact with Other Office Programs Part III: Advanced Techniques in Excel VBA 15: Charts and Graphs 16: Working with Databases 17: API Calls 18: Class Modules 19: Animation Part IV: VBA in Action 20: Converting Labels to Numbers and Numbers to Labels 21: Transposing a Range of Cells 22: Adding Formula Details into Comments 23: Calculating a Range 24: Reversing a Label 25: Who Created the Workbook? 26: Evaluating a Cell 27: Sorting Worksheets into Alphabetical Order 28: Replacing Characters in a String 29: Timed Events 30: Auto Totaling a Matrix of Numbers 31: Absolute and Relative Formulas 32: Coloring Alternate Rows and Columns of the Spreadsheet 33: Coloring Cells Containing Formulas 34: Summing Cells by Reference to a Master Cell 35: Globally Changing a Range of Values 36: Displaying Hidden Sheets Without a Password 37: Searching Multiple Sheets and Workbooks 38: Brighten Up Your Comments 39: An Alternative to Message Boxes 40: Working with Shapes 41: Turning Your VBA Code into an Add-In A: ASCII Character CodesNER(01): WOW