Excel 2010 Bible

Chapter 39: Introducing Visual Basic for Applications 799 Two Types of VBA Macros Before getting into the details of creating ma ...

Part VI: Programming Excel with VBA 800 The CurrentDate macro also includes a comment. Comments are simply notes to yourself, an ...

Chapter 39: Introducing Visual Basic for Applications 801 Cross-Reference Creating VBA functions that you use in worksheet formu ...

Part VI: Programming Excel with VBA 802 Creating VBA Macros Excel provides two ways to create macros: l (^) Turn on the macro re ...

Chapter 39: Introducing Visual Basic for Applications 803 Warning Shortcut keys assigned to macros take precedence over built-in ...

Part VI: Programming Excel with VBA 804 Examining the macro The macro was recorded in a new module named Module1. To view the co ...

Chapter 39: Introducing Visual Basic for Applications 805 Notice that Excel inserted some comments at the top of the procedure. ...

Part VI: Programming Excel with VBA 806 Another example This example demonstrates how to record a time-stamp macro that inserts ...

Chapter 39: Introducing Visual Basic for Applications 807 FIGURE 39.9 The TimeStamp procedure was generated by the Excel macro r ...

Part VI: Programming Excel with VBA 808 FIGURE 39.10 This TimeStamp macro works correctly. Testing the macro When Excel is activ ...

Chapter 39: Introducing Visual Basic for Applications 809 Normally, when you record a macro, Excel stores exact references to th ...

Part VI: Programming Excel with VBA 810 If you store macros in the Personal Macro Workbook, you don’t have to remember to open t ...

Chapter 39: Introducing Visual Basic for Applications 811 Draw the button on the worksheet. Excel displays the Assign Macro dia ...

Part VI: Programming Excel with VBA 812 The basics: Entering and editing code Before you can enter code, you must insert a VBA m ...

Chapter 39: Introducing Visual Basic for Applications 813 l (^) You perform actions in VBA by writing (or recording) code in a V ...

Part VI: Programming Excel with VBA 814 You can take it to still another level and refer to a specific cell as follows: Applicat ...

Chapter 39: Introducing Visual Basic for Applications 815 Most of these objects can contain other objects. For example, a Workbo ...

Part VI: Programming Excel with VBA 816 properties: You can determine where a cell is located (in which row and column), but you ...

Chapter 39: Introducing Visual Basic for Applications 817 that this workbook has one worksheet, named Summary. Your VBA code can ...

Part VI: Programming Excel with VBA 818 Controlling execution VBA uses many constructs that are found in most other programming ...