+ Reply to Thread
Results 1 to 2 of 2

How to Add a pop up menus with multiple menus levels

  1. #1
    Registered User
    Join Date
    07-01-2010
    Location
    Costa Rica
    MS-Off Ver
    Excel 2007
    Posts
    5

    How to Add a pop up menus with multiple menus levels

    Well as the title says, what i need is to make a pop menu in a sheet and I found a some solution (shown at the bottom) but I need to at least 4 level menus (sorry for my terrible english), and if its posible an action on all of the menus of eache level, just like in the code at the bottom, but with 4 or 5 levels. Thans in advance for your help.





    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    05-21-2009
    Location
    Great Britain
    MS-Off Ver
    Excel 2003
    Posts
    550

    Re: How to Add a pop up menus with multiple menus levels

    The code shows how to add 2 levels of menus, so just repeat the technique for the 3rd, 4th and 5th levels. Add each 1st level button (msoControlButton) or popup (msoControlPopup) to the CommandBar. Add each 2nd level button/popup to a 1st level popup. Add each 3rd level button/popup to a 2nd level popup, etc.
    Post responsibly. Search for excelforum.com

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1