Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Adding A Menu Bar To A User Form

  1. #1
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    13

    Adding A Menu Bar To A User Form

    Can you add a menu three to a userform - like a toolbar?
    xl2007 - Windows 7
    xl hates the 255 number

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,122
    Rep Power
    10

  3. #3
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    13
    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

  4. #4
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    13
    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

  5. #5
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,122
    Rep Power
    10
    May be Jaafar is the man to contact.

  6. #6
    Junior Member
    Join Date
    Apr 2011
    Posts
    6
    Rep Power
    0
    If you are using a modeless form, you could simply use the normal commandbars?

  7. #7
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    13
    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

  8. #8
    Junior Member
    Join Date
    Apr 2011
    Posts
    3
    Rep Power
    0
    This example adds a drop down menu to a CommandButton
    Attached Files Attached Files

  9. #9
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    13
    Thanks RoyUK - Guess I am going to have to use my commandbar.
    xl2007 - Windows 7
    xl hates the 255 number

  10. #10
    Junior Member
    Join Date
    Apr 2011
    Posts
    3
    Rep Power
    0
    Not sure what you mean, the userform has a commandButton which has a drop down menu when clicked
    Hope that helps

    excel tips & tricks

Similar Threads

  1. How to track user activity using a macro?
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 4
    Last Post: 08-10-2012, 06:50 PM
  2. Adding values less than zero
    By Howardc in forum Excel Help
    Replies: 3
    Last Post: 07-14-2012, 11:55 AM
  3. tracking changes and prompt user
    By princ_wns in forum Excel Help
    Replies: 1
    Last Post: 01-22-2012, 03:37 PM
  4. Adding Scroll bar to image box in vba
    By princ_wns in forum Excel Help
    Replies: 1
    Last Post: 12-13-2011, 09:47 PM
  5. Hide Ribbon and Formula Bar
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 04-21-2011, 07:03 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •