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
actions active add-in appears application argument array assign button called Cancel cell Chapter chart Choose close Code window collection column command constants contains copy create custom default describe determine develop dialog box displays End Sub enter error event example Excel execute Exit False Figure formula function Help Here’s Insert Integer look loop macro macro recorder message box method MsgBox Notice object occurs option perform procedure programming Project provides range Range object recorder refer result returns routine sheet shown shows simply specify statement steps stored string structure Sub procedure sure Table things True turn understand UserForm variable VBA code VBA module window workbook worksheet worksheet functions write