Excel 2019 Bible

Chapter 45: Using UserForm Controls in a Worksheet 45 FIGURE 45.2 Excel’s two sets of worksheet controls This chapter focuses ex ...

Part VI: Automating Excel Button What It Does Option Button Inserts an OptionButton control (to allow a user to select from mult ...

Chapter 45: Using UserForm Controls in a Worksheet 45 Adjusting properties Every control that you add has various properties tha ...

Part VI: Automating Excel The manner in which you change a property depends on the property. Some properties display a drop-down ...

Chapter 45: Using UserForm Controls in a Worksheet 45 Property Description Width and Height Values that determine the control’s ...

Part VI: Automating Excel FIGURE 45.4 Double-clicking a control in Design mode activates the VBE and enters an empty event- hand ...

Chapter 45: Using UserForm Controls in a Worksheet 45 Reviewing the Available ActiveX Controls The following sections describe t ...

Part VI: Automating Excel The following is a description of the most useful properties of a ComboBox control: BoundColumn If the ...

Chapter 45: Using UserForm Controls in a Worksheet 45 ListBox A ListBox control presents a list of items, and the user can selec ...

Part VI: Automating Excel ScrollBar A ScrollBar control is useful for specifying a cell value. Figure 45.6 shows a worksheet wit ...

Chapter 45: Using UserForm Controls in a Worksheet 45 SpinButton A SpinButton control lets the user select a value by clicking t ...

Part VI: Automating Excel IntegralHeight If TRUE, the height of the TextBox adjusts automatically to display full lines of text ...

997 C H A P T E R 46 Working with Excel Events IN THIS CHAPTER Understanding events Using workbook-level events Working with wor ...

Part VI: Automating Excel Entering Event-Handler VBA Code Every event-handler procedure must reside in a specific type of code m ...

Chapter 46: Working with Excel Events 46 (This event is triggered when a user activates a different sheet.) If you use the techn ...

Part VI: Automating Excel TA B L E 4 6 .1 Workbook Events Event Action That Triggers the Event Activate The workbook is activate ...

Chapter 46: Working with Excel Events 46 ■ (^) Activating a specific sheet ■ Ensuring that certain conditions are met; for examp ...

Part VI: Automating Excel Using the NewSheet event The following procedure executes whenever a new sheet is added to the workboo ...

Chapter 46: Working with Excel Events 46 A problem can arise from this event with unsaved workbooks. By the time the user sees t ...

Part VI: Automating Excel To get a feel for the types of actions that generate the Change event for a worksheet, enter the prece ...