Can you add a menu three to a userform - like a toolbar?
Can you add a menu three to a userform - like a toolbar?
xl2007 - Windows 7
xl hates the 255 number
Hi Rasm,
Find this great work from Ivan
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
xl2007 - Windows 7
xl hates the 255 number
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.
xl2007 - Windows 7
xl hates the 255 number
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.
xl2007 - Windows 7
xl hates the 255 number
This example adds a drop down menu to a CommandButton
Thanks RoyUK - Guess I am going to have to use my commandbar.
xl2007 - Windows 7
xl hates the 255 number
Not sure what you mean, the userform has a commandButton which has a drop down menu when clicked
Bookmarks