Hello Guys,
I am working with VBA and in contrast with VB6 there's no Menu Editor in Tools. How do I put a MenuBar on a form in VBA environment?
Thanks a lot,:hi:
Serge
Printable View
Hello Guys,
I am working with VBA and in contrast with VB6 there's no Menu Editor in Tools. How do I put a MenuBar on a form in VBA environment?
Thanks a lot,:hi:
Serge
HI Serge...
You can add the toolbar control to your toolbox by right clicking and adding controls...that would allow you to drag a toolbar onto a form. You can then add buttons and such...
I think that would work anyway...
Pete
Check this out for an impressive way to put a menu on a userform:
http://www.xcelfiles.com/API_Userform_MenuMaker.html
Only works on Excel 2000 and above.
Marcster.
Difficult!Quote:
Originally Posted by Autofreak
There are API solutions out there, but I have not found a stable free one yet.
Another solution, and my preferred option, is to to build a VB form, and use this in an Excel solution. However, this is decidedly more complex, and needs a full VB license.
If you are happy with just buttons, XLGibbs toolbar is an option
Hi Marcster,Quote:
Originally Posted by Marcster
Yeah! it is impressive. One problem , it can be modalless...and I can use it only when its ShowModal property is set to False. The author is saying that the right version is coming soon. But it's a great solution anyway. It's cool to be able to work with API's . Where do I start to learn that??
Thanks
Serge
I tried to put a toolbar and a few buttons on it but they slipped thru the toolbar and dropped to the form. How do I make them stay on the toolbar??
Thanks,
serge
How were you adding the buttons? If you were dragging buttons from the control toolbar to the form, that is why..
I haven't used toolbars on forms except for in VB, so I am just guessing that you have to add them using the commandbar.add(msoControlButton...) type syntax in code...
Similar to make a custom toolbar on the spreadsheet itself...just a guess though..
Here's some info to get you started. It's on MSDN:Quote:
Originally Posted by Autofreak
http://msdn.microsoft.com/library/de...windowsapi.asp
HTH,
Marcster.
Serge
To add buttons to the toolbar got to (Custom) on the properties sheet.
It looks good but it ain't exactly stable. I tried it once in a serious app and it hust couldn't be relied on, so I removed it.Quote:
Originally Posted by Autofreak
Thanks Guys,
those are very helpful tips!! I am gonna go with the toolbar. :thumb do I grade the ansewres on this forum?
Serge