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

Thread: Adding A Menu Bar To A User Form

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 04-23-2011, 10:04 AM #1
    Rasm
    Rasm is offline
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14

    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
    Reply With Quote Reply With Quote
  2. 04-23-2011, 10:38 AM #2
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    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
    Last edited by DocAElstein; 07-28-2024 at 02:16 PM.
    Reply With Quote Reply With Quote
  3. 04-23-2011, 07:31 PM #3
    Rasm
    Rasm is offline
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14
    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
    Reply With Quote Reply With Quote
  4. 04-26-2011, 02:46 AM #4
    Rasm
    Rasm is offline
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14
    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
    Reply With Quote Reply With Quote
  5. 04-26-2011, 07:16 AM #5
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    May be Jaafar is the man to contact.
    Reply With Quote Reply With Quote
  6. 04-28-2011, 05:21 PM #6
    excelgeek
    excelgeek is offline
    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?
    Reply With Quote Reply With Quote
  7. 04-29-2011, 03:00 AM #7
    Rasm
    Rasm is offline
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14
    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
    Reply With Quote Reply With Quote
  8. 04-29-2011, 04:48 PM #8
    royUK
    royUK is offline
    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
    Reply With Quote Reply With Quote
  9. 04-30-2011, 04:02 AM #9
    Rasm
    Rasm is offline
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14
    Thanks RoyUK - Guess I am going to have to use my commandbar.
    xl2007 - Windows 7
    xl hates the 255 number
    Reply With Quote Reply With Quote
  10. 05-03-2011, 05:33 PM #10
    royUK
    royUK is offline
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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

Bookmarks

Posting Permissions

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

Forum Rules