Skip to main content

CommandBars.Item property

Table of contents
  1. Syntax
  2. Parameters
  3. Example

Gets a CommandBar object from the CommandBars collection. Read-only.



expression Required. A variable that represents a CommandBars object.


Name Required/Optional Data type Description
Index Required Variant The name or index number of the object to be returned.


Item is the default member of the object or collection. The following two statements both assign a CommandBar object to cmdBar.

Set cmdBar = CommandBars.Item("Standard")
Set cmdBar = CommandBars("Standard")

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>