O'Reilly logo

Writing Excel Macros with VBA, 2nd Edition by Steven Roman PhD

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

&Print

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required