Excel 2019 Power Programming with VBA. Michael Alexander

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  29

      42  30

      43 31

      44  32

      45  33

      46  34

      47  35

      48  36

      49  37

      50  38

      51 39

      52 40

      53  41

      54  42

      55  43

      56  44

      57