Freigeben über

CommandBars.FindControls Method

  • Artikel
Office Developer Reference

Gets the CommandBarControls collection that fits the specified criteria.

Aa432152.vs_note(en-us,office.12).gif  Note
The use of CommandBars in some Microsoft Office applications has been superseded by the new Ribbon user interface. For more information, search help for the keyword "Ribbon."

Syntax

expression.FindControls(Type, Id, Tag, Visible)

expression   A variable that represents a CommandBars object.

Parameters

Name Required/Optional Data Type Description
Type Optional Variant Is one of the MsoControlType constants specfying 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
CommandBarControls

Remarks

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

Example
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.

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

See Also