VBA / XML dropdown in ribbon

**michiel soede** · 01-14-2015, 03:46 AM

Hi All,

Hope somebody can help me out. I created (on basis of an example on internet) an excel file with a ribbon that contains three dropdown menu's. The dropdown works but somehow I can't fetch the chosen items from the dropdown in a variable (although I included some on action code which should take care of it).

Doe somebody know how to change the code so that I can get the variable for example in a MSG box. See code for one drop down below
and the file attached.

Thanks in advance,

Michiel

Please Login or Register  to view this content.

**Tinbendr** · 01-14-2015, 05:48 PM

Everything I've found only returns the Index of the item selected.

So I change the XMl to

PHP Code:


<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<customUI onLoad="ribbonLoaded" xmlns="http://schemas.microsoft.com/office/2006/01/customui">
    <ribbon startFromScratch="false">
    <tabs>
      <tab id="myTab" label="MyTab">
        <group id="myGroupDD" label="Has Dropdown">
              <dropDown id="dd1" label="Dropdown" getItemCount="DDItemCount" getItemLabel="DDListItem" onAction="DDOnAction" getSelectedItemIndex="DDItemSelectedIndex"/>
        <dropDown id="dd2" label="Dropdown2" getItemCount="DDItemCount2" getItemLabel="DDListItem2" onAction="DDOnAction" getSelectedItemIndex="DDItemSelectedIndex2"/>
        <dropDown id="dd3" label="Dropdown3" getItemCount="DDItemCount3" getItemLabel="DDListItem3" onAction="DDOnAction" getSelectedItemIndex="DDItemSelectedIndex3"/>
</group>
      </tab>
    </tabs>
  </ribbon>
</customUI>

and added a select case to use the index as a reference of the range.

Please Login or Register  to view this content.

**michiel soede** · 01-15-2015, 10:35 AM

Subtile solution David. It works smooth :-)

Thanks very much.

Michiel

VBA / XML dropdown in ribbon

LinkBack

Thread Tools

Rate This Thread

Display

VBA / XML dropdown in ribbon

Re: VBA / XML dropdown in ribbon

Re: VBA / XML dropdown in ribbon

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Ribbon Change based on Non-Ribbon Object

[SOLVED] An alternative to the Add-Ins ribbon tab - Global Custom Ribbon Tab by Ken Puls

Populate dropDown in a custom ribbon on clicking a button

Ribbon - Multiple xlam adding into single Ribbon tab

Excel Ribbon dropdown

Bookmarks

Bookmarks

Posting Permissions