Skip to main content

CommandBars.FindControls method

Gets the CommandBarControls collection that fits the specified criteria.


expression.FindControls (TypeIdTagVisible)

expression A variable that represents a CommandBars object.


Name Required/Optional Data type Description
Type Optional Variant Is one of the MsoControlType constants specifying the type of control.
Id Optional Variant The control's identifier.
Tag Optional Variant The control's tag value.
Visible Optional Variant True to include only visible command bar controls in the search. The default value is False.

Return value



If no controls that fit the criteria are found, the FindControls method returns Nothing.


This example uses the FindControls method to return all members of the CommandBars collection that have an ID of 18 and displays (in a message box) the number of controls that meet the search criteria.

Dim myControls As CommandBarControls 
Set myControls = CommandBars.FindControls(Type:=msoControlButton, ID:=18) 
MsgBox "There are " & myControls.Count & _ 
    " controls that meet the search criteria."

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>