Appendix C. Command Bar Controls
In this appendix, we present a list of built-in command-bar controls, along with their ID numbers for use with the Add method of the CommandBarControls object.
Built-in Command-Bar Controls
Command-Bar Controls and Their Corresponding ID Numbers
|
<Custom> |
1 |
|
&Spelling |
2 |
|
&Save |
3 |
|
|
4 |
|
&New |
18 |
|
&Copy |
19 |
|
Cu&t |
21 |
|
&Paste |
22 |
|
Open |
23 |
|
Can’t Repeat |
37 |
|
&Microsoft Word |
42 |
|
Clear Contents |
47 |
|
Custom |
51 |
|
&Piggy Bank |
52 |
|
Custom |
59 |
|
&Double Underline |
60 |
|
Custom |
67 |
|
Custom |
68 |
|
&Close |
106 |
|
AutoFormat |
107 |
|
&Format Painter |
108 |
|
Print Pre&view |
109 |
|
Custom |
112 |
|
&Bold |
113 |
|
&Italic |
114 |
|
&Underline |
115 |
|
&Custom |
117 |
|
&Dark Shading |
118 |
|
&Align Left |
120 |
|
&Align Right |
121 |
|
&Center |
122 |
|
&Justify |
123 |
|
What’s &This? |
124 |
|
Custom |
126 |
|
&Undo |
128 |
|
&Redo |
129 |
|
&Line |
130 |
|
Te&xt Box |
139 |
|
&Find File |
140 |
|
&Top Border |
145 |
|
&Bottom Border |
146 |
|
&Left Border |
147 |
|
&Right Border |
148 |
|
Apply Inside Borders |
149 |
|
&Outside Borders |
150 |
|
Clear Border |
151 |
|
&Group |
164 |
|
&Ungroup |
165 |
|
Bring to Fron&t |
166 |
|
Send to Bac&k |
167 |
|
Bring &Forward |
170 |
|
Send &Backward |
171 |
|
F&ull Screen |
178 |
|
&Select Objects |
182 |
|
&Record New Macro |
184 |
|
&Macros |
186 |
|
Step Macro |
187 |
|
Resume Macro |
189 |
|
Flip &Horizontal |
196 |
|
Flip &Vertical |
197 |
|
Rotate &Right |
198 |
|
Rotate &Left |
199 |
|
&Freeform |
200 |
|
&Borders |
203 |
|
&Drawing |
204 |
|
&Edit Points |
206 |
|
Sort &Ascending |
210 |
|
Sort Des&cending |
211 |
|
&Edit Box |
219 |
|
&Check Box |
220 |
|
&Combo Box |
221 |
|
Control Properties |
222 |
Get Writing Excel Macros with VBA, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
