The Details pane (Figure
1-28) contains a hypertext link to the class or library to which the element belongs.
Some members have hypertext links to their parent class. For example, if the text in the
Details pane states that TextBox1 is declared as a text box type, clicking text box takes you
to the TextBox class. You can copy or drag text from the Details pane to the code window.
Figure 1-28. The Details pane
Split bar: This splits the panes so that you can adjust their size. There are split bars
between the following:
??? The Classes box and the ???Members of??? box
??? The Search Results list and the Classes and ???Members of??? boxes
??? The Classes and ???Members of??? boxes and the Details pane
Standard Code Modules
A standard module is a code module containing only procedure (Sub or Function), type, and
data declarations and definitions. Module-level declarations and definitions in a standard
module are public by default. In earlier versions of Visual Basic, a standard module was
referred to as a code module.
Whenever a new macro is created in an Excel session, a standard module is inserted into
the workbook to hold the macro. Any additional macros created in that session will also be
inserted into this standard module. Once the workbook is closed and reopened, Excel will
create a new standard module if the Macro Recorder is invoked.
nNote You will have to copy and paste your code if you want to keep it in one place or provide a specific
location for your code.
Pages:
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53