Creating a Custom Drop Down Menu

Hi everyone,

It's my first post on this forum so be kind. =)

I want to make an Add-in that creates a *custom drop down menu*. In the drop down menu, I would like to be able to click/run different macros I already wrote.

Furthermore, I would like the add-in to also create a *custom toolbar* with each button representing a different macro (again, those I've already written).

My problem is that I can't seem to find which command to pick (I think msoControlDropdown might be it?). Also, I've looked at some code online but they all specify a Weight/Lenght...really? Isn't there a standard control I can use?

Any help would be appreciated (even links and references).

I'm using Excel 2002.

Thanks.

Alex

Try this

http://www.ozgrid.com/VBA/custom-menus.htm

Thanks MartinLeyland.

That link was very helpful. I've adapted the code for my needs. That said, would you have any other useful links for creating a custom toolbar?