Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Menus in Userforms (97 SR2)

    I'd like to add standard menus to a userform. Does anyone have any idea if this is possible or how I might achieve it?
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  2. #2
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Menus in Userforms (97 SR2)

    I can't think of a way to do this directly, but I'd approach it from the angle below:

    Private Sub CommandButton1_Click()
    CommandBars("test").Visible = True
    End Sub

    Of course, you still have positioning and getting rid of the commandbar after you've used it to worry about... Still, hopefully that'll set the ball rolling.

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Menus in Userforms (97 SR2)

    I take it getting VB proper is not an option?
    You could use standard labels on your form and have the click event open a new small form with its own labels etc. but at this point you're stretching what userforms are designed for I think. You might also do a search and see if you can find an ActiveX toolbar control from somewhere.
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Menus in Userforms (97 SR2)

    VB Proper isn't an option unfortunately... I had hoped for a simpler option, the task of creating a menu from scratch is quite daunting.. but not impossible. [img]/forums/images/smilies/smile.gif[/img]

    If anyone has insight on a simpler method, It would be much appreciated! [img]/forums/images/smilies/smile.gif[/img]
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

Posting Permissions

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