Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    4

    Unanswered: Excel drop down menus

    Hi peeps, I was hopin someone cud enlighten me!! haha!
    I need to create drop down menu in Excel that can help people navigate from one sheet 2 another. How can this be done. Are there ne articles that can put me in the right direction?
    Thanks for ne hlp
    James

  2. #2
    Join Date
    Sep 2003
    Location
    Cincinnati, Oh USA
    Posts
    203

    Re: Excel drop down menus

    Here are 3 ways to accomplish this.
    1. Using VBA, create command buttons on your menu sheet and then
    on the click function use the sheet2.open command.
    2. Use a forms command button and assign a macro to that button that that has been recorded to move from sheet 1 to sheet 2
    or
    3. This is the easiest, use hyperlinks to the sheet from sheet1


    Originally posted by jaime1985
    Hi peeps, I was hopin someone cud enlighten me!! haha!
    I need to create drop down menu in Excel that can help people navigate from one sheet 2 another. How can this be done. Are there ne articles that can put me in the right direction?
    Thanks for ne hlp
    James
    Rick Knight
    KnightShift Office Solutions and Horse Breaking
    VB, VBA, FileMaker, Access Solutions, Web Solutions

Posting Permissions

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