Add-In Menu Creation

[srinivas1104]

Hi,

I have created a new Add-In menu using XML <CustomUI>. The menu is created successfully along with buttons, controls, etc. I wanted a comboBox to display all styles within in. For this, I have written the code: <comboBox idMso="StyleGalleryClassic"/>. However, this comboBox is not shown. If I change the code to <gallery idMso="StyleGalleryClassic"/>, then the Style List is shown. But I want the list to be shown in comboBox. Can someone help me? I am using Excel 2007. I am also posting the code below:

Please Login or Register  to view this content.

Thanks in advance,

Srinivas

[Andy Pope]

How exactly is the combobox suppose to display the information that is possible in a gallery? The combobox will only be a list of text.

[srinivas1104]

Hi,

Thanks for your message. I am not sure whether comboBox can be used along with StyleGalleryClassic. I have referred this in the below link:

http://social.msdn.microsoft.com/For...-88b2346f8cf6/

We have an Add-in Menu created by previous programmer wherein there is a dropdown/comboBox which has style of Activecell. Upon clicking, it will show all styles available in the Workbook. I want similar feature in my Add-in Menu. I wish to create a dropdown/comboBox which can show style of ActiveCell and also upon clicking can show list of all styles.

I have another questions. Using the same Add-in Menu, by using a label or editBox, can I display the ActiveCell's columnwidth.

Your help is greatly appreciated. I need to submit my project by 17th May.

Regards,

Srinivas

[Andy Pope]

Please keep all posts in this thread unless invited to directly contact a member.

The dropdown appears in the Add-in tab in xl2007 because it is constructed using the old commandbars methods.
You want to use the new ribbonx method and I don't think you can reference the old commandbar directly in ribbonx. You can do it in vba.

So you would need to have a dropdown control that you populate and maintain via code.