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

Contents

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