Excel VBA CommandBars(n).Name の実行結果

ken3memo.hatenablog.com
↑で使用する、メニューの名前がわからないとき、、

右クリック メニューへ マクロを追加したい時、
どのメニューか？調べる時に使ってみてください。

現在の設定をExcelシートへ書き出してみました。

Sub CommandBarの内容をセルに書き出す()
    Dim n As Integer
    Dim y As Integer
    Dim x As Integer
   
    y = 2
    For n = 1 To CommandBars.Count  'いつものように.Count分ループ
        Cells(y, "A") = CommandBars(n).Name  '名前が付いてます CommandBars("名前")で使えます
        Cells(y, "B") = CommandBars(n).Controls.Count  '↑のコマンド数、アクションの数
        For x = 1 To CommandBars(n).Controls.Count
            Cells(y, x + 2) = CommandBars(n).Controls(x).Caption  'ココでは表題を横に書き込みます
        Next x
        y = y + 1  '1コマンド1行にしたいので、次のセット位置へ
    Next
    
    MsgBox "終了"
End Sub

出力結果(A列の名前のみですが)

NAME CommandBars(n).Name '名前が付いてます CommandBars("名前")で使えます

---

Worksheet Menu Bar
Chart Menu Bar
WordArt
Picture
Drawing Canvas
Organization Chart
Diagram
Ink Drawing and Writing
Ink Annotations
Standard
Formatting
PivotTable
Chart
Reviewing
Forms
Stop Recording
External Data
Formula Auditing
Full Screen
Circular Reference
PivotChart Menu
Visual Basic
Web
Control Toolbox
Exit Design Mode
Refresh
Watch Window
PivotTable Field List
Workbook Queries
Data Catalog Search
Shared Queries
Queries and Connections
Borders
Protection
Text To Speech
List
Compare Side by Side
Workbook tabs
Cell
Column
Row
Cell
Column
Row
Ply
XLM Cell
Document
Desktop
Nondefault Drag and Drop
AutoFill
Button
Dialog
Series
Plot Area
Floor and Walls
Trendline
Chart
Format Data Series
Format Axis
Format Legend Entry
Formula Bar
PivotTable Context Menu
Query
Query Layout
AutoCalculate
Object/Plot
Title Bar (Charting)
Layout
Pivot Chart Popup
Phonetic Information
Auto Sum
Paste Special Dropdown
Find Format
Replace Format
List Range Popup
List Range Layout Popup
XML Range Popup
List Range Layout Popup
Nil
Filter Names
Excel Previewer
&Legacy Keyboard Support
Row
Column
Drawing
Shadow Settings
3-D Settings
Borders
Borders
Draw Border
Chart Type
Pattern
Font Color
Fill Color
Line Color
Drawing and Writing Pens
Annotation Pens
Drawing and Writing Pens
Annotation Pens
Order
Nudge
Align or Distribute
Rotate or Flip
Lines
Connectors
AutoShapes
Callouts
Flowchart
Block Arrows
Stars & Banners
Basic Shapes
Insert Shape
Shapes
Inactive Chart
Excel Control
Curve
Curve Node
Curve Segment
Pictures Context Menu
OLE Object
ActiveX Control
WordArt Context Menu
Rotate Mode
Connector
Script Anchor Popup
Canvas Popup
Organization Chart Popup
Diagram
Layout
Select
Share
Version History
Task Pane

Property Editor
Office Clipboard
XML Source
Research
XML Document
Signatures
Document Actions
Clip Art
Selection
Format Object
Document Management
Document Updates
Mail Merge Panes
Fax Service
Meeting Workspace
Attachment Options
Accessibility
Editor
Dictionaries
Thesaurus
History
Smart Lookup
Researcher
Insert From File
Help
Online Content
Alt Text
Feedback
Data Selector
Comments
Contact Support
Troubleshooter
Activity
Admin Tenant Portal
Notifications
User Voice
Search Feedback
Reading Order
Do more with Surface
Outlook Room Finder Pane
Changes
Ribbon Adapter
Add Command
Built-in Menus
Clipboard
Envelope

Status Bar
Ribbon

---

有名な
Cell や Row 以外は、なんか、イメージが付きにくいけど、
こんなにいっぱいあるんだぁ・・・・