litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

Excel - CommandBarControlCount

Syntax:
=CommandBarControlCount(Index)

Description:
Returns the number of controls on a particular commandbar.

Index: the commandbar for which the controls should be counted.

Example:
Determine the number of controls on commandbar 1.
=CommandBarControlCount(1)
Determine the number of controls on the Worksheet Menu Bar.
=CommandBarControlCount("Worksheet Menu Bar")