[RESOLVED] Excel VBA - Add Menu Items To UserForm

[Hack]

After spending a fair a bit of time searching around both on VBF and the net in general, I ran across this with respect to adding a dropdown menu bar to an Excel UserForm

notionally you can't. the forms object model doesn't support menus. You can do it in VB, but not VBA. There have been some kludge workarounds, but I wouldn't recommend it unless absolutely crucial to you

Is this pretty much the case?

[pgag45]

I have a pop up menus in my current project...

and I used to have them configured to command buttons at the top (say buttons that say File, Save, Tools, etc..), so that the pop up menu appears when clicking that command button.

Not sure if that's what you're looking for though.

[Hack]

That is exactly what I'm looking for.

Can you post an example?

[Siddharth Rout]

or this?

[pgag45]

When I first started I used RobDog's Guide...

http://www.vbforums.com/showthread.php?t=402050

I ran into some problems implementing the bars ( http://www.vbforums.com/showthread.php?t=473068 ), but eventually got them to work well... They really add a lot of functionality and make the project look very professional!

Hope this helps... good luck. I did spend quite some time getting these to work well, so let me know if you run into problems.

[Hack]

Thanks, I'll take a look at both suggestions (I knew Rob had a bunch of Excel stuff out there, but I didn't realize it covered this topic).

BTW: Congrats on 3K koolsid!

[Siddharth Rout]

BTW: Congrats on 3K koolsid!

Strange it is always you who notice these things I remember you doing that for 2k as well

Thanks

Check out the link it is amazing....

[Hack]

or this?

When I click on the zip file to download it, I get sent to downloadcounter.com and see no mention of menumaker_UF_API.xls

Am I missing something?

[Siddharth Rout]

Hi Hack...

I almost forgot about this one.... I guess I am growing old...

Yes, the above link is not working any more...

Here is another one that works....

http://www.dailydoseofexcel.com/arch...on-a-userform/

or you can directly download it from here

http://www.jkp-ads.com/downloadscrip...erFormMenu.zip

I personally downloaded the file and checked it... it works awesome

Also check out several comments at the bottom...
Hope this helps...

Sorry for the delay...

[Hack]

Thanks....I will check it out.

[Hack]

Although it took a while, I finally got the chance to play with the links koolsid posted, and got what I needed from them.