Skip to main content

item Element

The item element is used to create static items that must be used within a gallery, comboBox, or dropDown.

Graphical View of item Attributes

The following figure shows all the visible graphical attributes you can set on the item control.

This is specified using the following XML:

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui"
          onLoad="IRibbonUI_onLoad">
	<!--true: show only your tab in Excel-->
	<ribbon startFromScratch="true">
		<tabs>
			<tab id="customTab"
			     label="Custom Tab">
				<group id="customGroup"
				       label="Custom Group">
					<dropDown id="ddSelectColor"
					          label="Select Color">
						<item id="ItemColor_0"
						      label="White"
						      imageMso="AppointmentColor0"
						      screentip="White"
						      supertip="This is White!"/>
						<item id="ItemColor_1"
						      label="Red"
						      imageMso="AppointmentColor1"
						      screentip="Red"
						      supertip="This is Red!"/>
						<item id="ItemColor_2"
						      label="Blue"
						      imageMso="AppointmentColor2"
						      screentip="Blue"
						      supertip="This is Blue!"/>
					</dropDown>
				</group>
			</tab>
		</tabs>
	</ribbon>
</customUI>

Parent Elements

Children Elements

The item element does not support child objects of any kind, so it cannot have any embedded controls.

Required Attributes

The item element has only one attribute, the id. Unlike other elements, there is no idMso or idQ attribute available for the item control.

ATTRIBUTE WHEN TO USE
id Create your own item

Optional Attributes and Callbacks

STATIC ATTRIBUTE DYNAMIC ATTRIBUTE ALLOWED VALUES DEFAULT VALUE VBA CALLBACK SIGNATURE FOR DYNAMIC ATTRIBUTE
image (none) 1 to 1024 characters (none) (none)
imageMso (none) 1 to 1024 characters (none) (none)
label (none) 1 to 1024 characters (none) (none)
screentip (none) 1 to 1024 characters (none) (none)
supertip (none) 1 to 1024 characters (none) (none)

Using Built-in item Controls

Excel doesn't have a built-in item element.

Creating Custom item Controls

Please read the section: Graphical View of item Attributes

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>