I need a menu bar in a userform

[arkitektor]

I need to a userform with a toolbar or a menu bar, i found this file, but as a beginner i need something more simple, but with almost the same interface that this file shows. something like the method to add a new commandbar to the excel default toolbar.

so please help me

[Bob Phillips]

Quite honestly, because VBA don't support menus natively, this is about as simple as it gets. My two methods, building the form in a VB6 dll and calling it from VBA, or VBA menus, are both even more complicated.

[Bob Phillips]

I lie. I suggested a simpler example myself in http://www.vbaexpress.com/forum/showthread.php?t=11016&highlight=userform+menu

[arkitektor]

Ya estuve probando el codigo que ofreciste a marian y realmente es una solucion mucho mas sencilla, ahora tengo una pregunta, es posible con este metodo hacer crear un submenu dentro de un menu popup. Por ejemplo hacerle un submenu a dataform???
Se que es mucho pedir... es solo una pregunta, pero con lo que tengo ahorita me doy por satisfecho

Muchas Gracias!!!!