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
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