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.

Syntax

expression.Item(Index)

expression Required. A variable that represents a CommandBars object.

Parameters

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

Example

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>