Adding A Menu Bar To A User Form

Can you add a menu three to a userform - like a toolbar?

Hi Rasm,

Find this great work from Ivan


https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.youtube.com/watch?v=bRd4mJglWiM&lc=UgxRmh2gFhpmHNnPemR4AaABAg. A0opm95t2XEA0q3KshmuuY
https://www.youtube.com/watch?v=bRd4mJglWiM&lc=UgxRmh2gFhpmHNnPemR4AaABAg
https://eileenslounge.com/viewtopic.php?p=318868#p318868
https://eileenslounge.com/viewtopic.php?p=318311#p318311
https://eileenslounge.com/viewtopic.php?p=318302#p318302
https://eileenslounge.com/viewtopic.php?p=317704#p317704
https://eileenslounge.com/viewtopic.php?p=317704#p317704
https://eileenslounge.com/viewtopic.php?p=317857#p317857
https://eileenslounge.com/viewtopic.php?p=317541#p317541
https://eileenslounge.com/viewtopic.php?p=317520#p317520
https://eileenslounge.com/viewtopic.php?p=317510#p317510
https://eileenslounge.com/viewtopic.php?p=317547#p317547
https://eileenslounge.com/viewtopic.php?p=317573#p317573
https://eileenslounge.com/viewtopic.php?p=317574#p317574
https://eileenslounge.com/viewtopic.php?p=317582#p317582
https://eileenslounge.com/viewtopic.php?p=317583#p317583
https://eileenslounge.com/viewtopic.php?p=317605#p317605
https://eileenslounge.com/viewtopic.php?p=316935#p316935
https://eileenslounge.com/viewtopic.php?p=317030#p317030
https://eileenslounge.com/viewtopic.php?p=317030#p317030
https://eileenslounge.com/viewtopic.php?p=317014#p317014
https://eileenslounge.com/viewtopic.php?p=316940#p316940
https://eileenslounge.com/viewtopic.php?p=316927#p316927
https://eileenslounge.com/viewtopic.php?p=316875#p316875
https://eileenslounge.com/viewtopic.php?p=316704#p316704
https://eileenslounge.com/viewtopic.php?p=316412#p316412
https://eileenslounge.com/viewtopic.php?p=316412#p316412
https://eileenslounge.com/viewtopic.php?p=316254#p316254
https://eileenslounge.com/viewtopic.php?p=316046#p316046
https://eileenslounge.com/viewtopic.php?p=317050&sid=d7e077e50e904a138c794e1 f2115da95#p317050
https://www.youtube.com/@alanelston2330
https://www.youtube.com/watch?v=yXaYszT11CA&lc=UgxEjo0Di9-9cnl8UnZ4AaABAg.9XYLEH1OwDIA35HNIei0z-
https://eileenslounge.com/viewtopic.php?p=316154#p316154
https://www.youtube.com/watch?v=TW3l7PkSPD4&lc=UgwAL_Jrv7yg7WWC8x14AaABAg
https://teylyn.com/2017/03/21/dollarsigns/#comment-191
https://eileenslounge.com/viewtopic.php?p=317050#p317050
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

Perfect - he gives a lot of history and older downloads - but if you read it - then you find a great example in MenuMaker_UFrmAPI.xls download. Thanks - this will keep me busy for a while. After the Honey do list - lol

The code from Ivan is cool - however it does not support vbmodeless when the userform is loaded. I did send Ivan a mail - unfortunately he never got around to add that feature. I will have to work around that - thanks again - appreciate all the help. My code is progressing nicely.

May be Jaafar is the man to contact.

If you are using a modeless form, you could simply use the normal commandbars?

Excelgeek - I am looking for a menu style drop downs on a userform - as far as I know that is not an option. if that is not true - I would be very interested in knowing how to do that.

This example adds a drop down menu to a CommandButton

Thanks RoyUK - Guess I am going to have to use my commandbar.

Not sure what you mean, the userform has a commandButton which has a drop down menu when clicked

If you look in post #2 & #3 of this thread - Excelfox gives a link to work by Ivan - there is a lot of reading - but in Post #3 I give the name of the file to download - a real cool piece of work by Ivan that shows how to add Menus to a userform - however it does not work in Modal=False or vbmodeless. I actually wrote Ivan and asked him - but he never got around to finish that part. Anyway that is the only good way I have found to have a menu structure on the userform itself (in compiled mode - not design mode). But I need it to work as vbmodeless - I hope ths explains what I am looking for.

RoyUK - ahhh just checked your site - nice work - added you 2 favorites.

Thanks for the thumbs up on the site, I will be updating it soon.

I read that you wanted the menu to work modelessly & the example that I posted will do that.

RoyUK - My appologies - I have several dowloads on this issue - I was looking at wrong one - yes - you are right - I will def check it out - sorry again

RoyUK - Perfect - I just added your code to my userform - precisely what I was looking for - :):cool:

You really should upload this under cool code - I have looked quite a long time for something like this - in addition the code is easy to work with. I have to play with this - But I assume I can actually place the Button right on my sheet - hmmm - that may work well for certain operations - this is very cool. Thanks a bunch - I was slow to pick up - good thing you stuvck with it - lol.