+ Reply to Thread
Results 1 to 6 of 6

help with submenu

  1. #1
    Registered User
    Join Date
    12-30-2006
    Posts
    6

    help with submenu

    hi there,

    let me first thank you all for all the info and stuff on this site/forum that helped me alot with my excel knowledge.

    in this tread i need help with creating more then 1 submenu.
    most of the code i found on http://www.ozgrid.com/VBA/excel-add-in-create.htm
    the problem is how do i create another menu that will lead off to another menu?
    in other words how do i create more then 1 ControlPopup?

  2. #2
    Forum Contributor
    Join Date
    11-29-2003
    Posts
    1,203
    Repeat the code for:
    Please Login or Register  to view this content.
    This will add another pop-up (drop down) menu.

    Keep repeating exactly the same code over and over and you will get exactly the same menu items over and over. Then, go back and change the parts you want to change (like captions, icons, and "on action" macros).

    Hope this answered the question.

  3. #3
    Registered User
    Join Date
    12-30-2006
    Posts
    6
    indeed i thought it would but the question is where to put the code.
    i tried a few options but the other popupmenu goes in the previous popupmenu.
    i dont get how to put 2 or more popupmenus below each other.
    Last edited by secretk; 12-30-2006 at 11:10 PM.
    i am EXCELlent in EXCELling my brains with EXCEL

  4. #4
    Forum Contributor
    Join Date
    11-29-2003
    Posts
    1,203

    Oops ... sorry, I misunderstood the question

    Well, no wonder I thought the answer was so easy! I was answering the wrong question!!!

    Sorry, I have never tried to put multiple layer down-downs. Tell ya what I suspect the answer is ... it can be done but only with great difficulty. You basically have to figure out where in space the command bar is and then create another, floating command bar in the exact spot you want it in.

    Hope for your sake I'm wrong. I'll be watching to see what comes up here.

  5. #5
    Forum Contributor
    Join Date
    03-15-2005
    Location
    North Carolina
    MS-Off Ver
    2003 & 2007
    Posts
    180
    Give this a shot.

    Please Login or Register  to view this content.
    HTH
    jtp

  6. #6
    Registered User
    Join Date
    12-30-2006
    Posts
    6

    thxs man

    yes that works
    thxs jtp
    i was wondering wot this piece of code means in plain english coz im still learning.

    Please Login or Register  to view this content.
    below code indeed adds another popupmenu item below the other.

    Please Login or Register  to view this content.

+ 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