PDA

View Full Version : I need a menu bar in a userform



arkitektor
09-22-2007, 07:24 PM
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
09-23-2007, 01:12 AM
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
09-23-2007, 01:22 AM
I lie. I suggested a simpler example myself in http://www.vbaexpress.com/forum/showthread.php?t=11016&highlight=userform+menu

arkitektor
09-23-2007, 11:57 AM
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!!!!