Excel 2019 Power Programming with VBA. Michael Alexander

Чтение книги онлайн.

СКАЧАТЬ in a custom Ribbon group.FIGURE 17.17 This group contains built-in controls.FIGURE 17.18 This Ribbon group contains two galleries.FIGURE 17.19 A gallery that displays month names, plus a buttonFIGURE 17.20 A gallery of imagesFIGURE 17.21 The dynamicMenu control lets you create a menu that varies depen...FIGURE 17.22 Using the Customize Ribbon tab of the Excel Options dialog box t...FIGURE 17.23 An old-style toolbar, located in the Custom Toolbars group of th...

      18 Chapter 18FIGURE 18.1 A simple macro generates a list of all shortcut menus.FIGURE 18.2 Displaying the Caption property for controlsFIGURE 18.3 Listing the items in all shortcut menusFIGURE 18.4 The Cell shortcut menu with a custom menu itemFIGURE 18.5 This shortcut menu has a submenu with three submenu items.FIGURE 18.6 A new shortcut menu appears only when the user right-clicks a cel...

      19 Chapter 19FIGURE 19.1 Using cell comments to display helpFIGURE 19.2 Using a shape object with text to display help for the userFIGURE 19.3 An easy method is to put user help in a separate worksheet.FIGURE 19.4 Clicking one of the arrows on the SpinButton changes the text dis...FIGURE 19.5 Inserting a Label control inside a Frame control adds scrolling t...FIGURE 19.6 Using a drop-down list control to select a help topicFIGURE 19.7 Displaying help in a web browserFIGURE 19.8 Displaying an MHTML file in a web browserFIGURE 19.9 An example of HTML HelpFIGURE 19.10 Using HTML Help Workshop to create a help fileFIGURE 19.11 Specify a context ID for a custom function.

      20 Chapter 20FIGURE 20.1 An empty class module named CNumLockFIGURE 20.2 A message box shows the change in status of the Num Lock key.FIGURE 20.3 A web query for financial informationFIGURE 20.4 The code pane lists available events.FIGURE 20.5 After a web query is refreshed, the last update time is recor...FIGURE 20.6 Excel tables hold the information for the objects.FIGURE 20.7 The commission calculation is output to the Immediate Window.

      21 Chapter 21FIGURE 21.1 Compatibility CheckerFIGURE 21.2 A summary report from Microsoft Office Code Compatibility Inspect...FIGURE 21.3 The wizard demo in English, Spanish, and German

      Guide

      1  Cover

      2 Table of Contents

      3  Begin Reading

      Pages

      1  iii

      2  iv

      3  v

      4  vii

      5  ix

      6  xi

      7  xxxiii

      8  xxxiv

      9  xxxv

      10  xxxvi

      11 xxxvii

      12  xxxviii

      13  xxxix

      14  1

      15  3

      16 4

      17  5

      18  6

      19 7

      20  8

      21  9

      22  10

      23  11

      24  12

      25  13

      26 14

      27  15

      28  16

      29  17

      30  18

      31  19

      32  20

      33 21

      34  22

      35  23

      36  24

      37  25

      38  26

      39  27

      40  28

      41  СКАЧАТЬ