CommandBar.FindControl method (Office)
Gets a CommandBarControl object that fits a specified criteria.
Note
The use of CommandBars in some Microsoft Office applications has been superseded by the new ribbon component of the Microsoft Office Fluent user interface. For more information, see Overview of the Office Fluent ribbon.
Syntax
expression.FindControl (Type, Id, Tag, Visible, Recursive)
expression A variable that represents a CommandBar 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. |
| Recursive | Optional | Variant | True to include the command bar and all of its pop-up subtoolbars in the search. This argument only applies to the CommandBar object. The default value is False. |
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.
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.