FindControl Method

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

                          

Returns a CommandBarControl object that fits a specified criteria.

Syntax

expression**.FindControl(Type**, Id, Tag, Visible, Recursive)

expression   Required. An expression that returns a CommandBars object.

Type   Optional Variant. The type of control. Can be one of the following MsoControlType constants:

msoControlActiveX msoControlCustom msoControlButton msoControlEdit msoControlDropdown msoControlComboBox msoControlButtonDropdown msoControlSplitDropdown msoControlGenericDropdown msoControlGraphicCombo msoControlSplitButtonMRUPopup msoControlSplitExpandingGrid

msoControlGraphicDropdown msoControlPopup msoControlGraphicPopup msoControlButtonPopup msoControlGauge msoControlLabel msoControlExpandingGrid msoControlGrid msoControlOCXDropDown msoControlSplitButtonPopup msoControlPane

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 Boolean. True to include the command bar and all of its pop-up subtoolbars in the search. The default value is False.

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.