Excel 2010 Bible

859 CHAPTER Using UserForm Controls in a Worksheet IN THIS CHAPTER Why use controls on a worksheet? Using controls The Controls ...

Part VI: Programming Excel with VBA 860 On the CD This workbook is available on the companion CD-ROM. The file is named mortgage ...

Chapter 42: Using UserForm Controls in a Worksheet 861 FIGURE 42.2 Excel’s two sets of worksheet controls. TABLE 42.1 ActiveX Co ...

Part VI: Programming Excel with VBA 862 Adding a control To add a control to a worksheet, choose Developer ➪ Controls ➪ Insert. ...

Chapter 42: Using UserForm Controls in a Worksheet 863 The manner in which you change a property depends upon the property. Some ...

Part VI: Programming Excel with VBA 864 TABLE 42.2 Properties Shared by Multiple Controls Property Description AutoSize If True, ...

Chapter 42: Using UserForm Controls in a Worksheet 865 ActiveX control on Sheet2, the VBA code for that control is stored in the ...

Part VI: Programming Excel with VBA 866 Double-click the button. The VB Editor window is activated, and an empty Sub procedure ...

Chapter 42: Using UserForm Controls in a Worksheet 867 l (^) LinkedCell: The worksheet cell that’s linked to the CheckBox. The c ...

Part VI: Programming Excel with VBA 868 Cross-Reference You can also create a drop-down list directly in a cell, by using data v ...

Chapter 42: Using UserForm Controls in a Worksheet 869 l (^) IntegralHeight: This is TRUE if the height of the ListBox adjusts a ...

Part VI: Programming Excel with VBA 870 FIGURE 42.6 This worksheet has three ScrollBar controls. The following is a description ...

Chapter 42: Using UserForm Controls in a Worksheet 871 l (^) Max: The maximum value of the control. l LinkedCell: The worksheet ...

Part VI: Programming Excel with VBA 872 l (^) MultiLine: If True, the TextBox can display more than one line of text. l TextAlig ...

873 CHAPTER Working with Excel Events IN THIS CHAPTER Understanding events Using workbook-level events Working with worksheet ev ...

Part VI: Programming Excel with VBA 874 Entering Event-Handler VBA Code Every event-handler procedure must reside in a specific ...

Chapter 43: Working with Excel Events 875 Some event-handler procedures contain an argument list. For example, you may need to c ...

Part VI: Programming Excel with VBA 876 TABLE 43.1 Workbook Events Event Action That Triggers the Event Activate The workbook is ...

Chapter 43: Working with Excel Events 877 l (^) Displaying welcome messages. l Opening other workbooks. l (^) Activating a speci ...

Part VI: Programming Excel with VBA 878 Using the SheetActivate event The following procedure executes whenever the user activat ...