Skip to main content

CommandBars.FindControl method

Gets a CommandBarControl object that fits a specified criteria.

Syntax

expression.FindControl (TypeIdTagVisible)

expression A variable that represents a CommandBars object.

Parameters

Name Required/Optional Data type Description
Type Optional Variant The type of control.
Id Optional Variant The identifier of the control.
Tag Optional Variant The tag value of the control.
Visible Optional Variant True to include only visible command bar controls in the search. The default value is False. Visible command bars include all visible toolbars and any menus that are open at the time the FindControl method is executed.

Return value

CommandBarControl

Remarks

If the CommandBars collection contains two or more controls that fit the search criteria, FindControl returns the first control that's found. If no control that fits the criteria is found, FindControl returns Nothing.

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>