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

Excel - CommandBarControlCaption

Syntax:
=CommandBarControlCaption(CommandBarIndex, ControlIndex)

Description:
Returns the caption of a commandbar control.

CommandBarIndex: The commandbar on which the control occurs.
ControlIndex: The index of the control.

Example:
Return the caption of control 1 on commandbar 1.
=CommandBarControlCaption(1,1)
Return the caption of the second control on the Worksheet Menu Bar.
=CommandBarControlCaption("Worksheet Menu Bar",2)