Excel 2007 VBA Programming For DummiesJohn Wiley & Sons, 08/02/2011 - 384 páginas Step-by-step instructions for creating VBA macros Harness the power of VBA and create custom Excel applications Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more. Discover how to
|
Índice
1 | |
9 | |
Part II How VBA Works with Excel | 33 |
Part III Programming Concepts | 91 |
Part IV Communicating with Your Users | 221 |
Part V Putting It All Together | 315 |
Part VI The Part of Tens | 345 |
355 | |
Bonus Chapter 1 Interacting with Other Office Applications | 369 |
Bonus Chapter 2 Ten VBA Dos and Donts | 381 |
Outras edições - Ver tudo
Palavras e frases frequentes
activate the VBE add-in argument array bugs built-in button Cancel Caption cell A1 cell.Value Chapter chart Click OK Code window column command CommandBar constants contains create CubeRoot custom function data type debugging declare default displays a message double-click End Sub enter Error Resume event Excel displays execute the macro Exit Sub False filename following example following statement formula Function procedure Help system Here's Immediate window Integer ListBox Macro dialog box macro recorder message box method Microsoft Excel Microsoft Office Excel MsgBox function MultiPage control Object Browser OptionButtons Private Sub programming Properties window Range object Record Macro refer returns right-click routine shortcut key shortcut menu shown in Figure shows specify SpinButton Sub procedure syntax TextBox ThisWorkbook toolbar True user clicks UserForm variable VBA code VBA module VBA procedure Visual Basic Workbook object worksheet functions Worksheet object