Adding A Menu Bar To A User Form

[Rasm]

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.

[Rasm]

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

[royUK]

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.

[Rasm]

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

[Rasm]

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

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.