+ Reply to Thread
Results 1 to 6 of 6

Combo Box to select sheets

  1. #1
    Forum Contributor
    Join Date
    07-30-2012
    Location
    Leeds
    MS-Off Ver
    Excel 2013
    Posts
    177

    Combo Box to select sheets

    Hello all,
    I have a large wookbook and I want to put a combo box on the menu page to allow users to select the sheet to navigate to. Is this possible?

    Many thanks

    Luke

  2. #2
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Combo Box to select sheets

    Hi,

    Try the code in this attachment.

    Hope this helps
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    07-30-2012
    Location
    Leeds
    MS-Off Ver
    Excel 2013
    Posts
    177

    Re: Combo Box to select sheets

    Hi Ajryan - works great!

    Sorry to complicate it - is there any way to get it so that the combo box only shows sheets that have names beginning with a number?

    Cheers

    Luke

  4. #4
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Combo Box to select sheets

    Hi,

    There sure is. Change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    in my code.

    Hope this helps

  5. #5
    Forum Contributor
    Join Date
    07-30-2012
    Location
    Leeds
    MS-Off Ver
    Excel 2013
    Posts
    177

    Re: Combo Box to select sheets

    You absolute gent! Works like a charm!

  6. #6
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Combo Box to select sheets

    No problems!

    Please don't forget to click on the * next to my post(s) to say thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Combo box to select column
    By Duguid1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-13-2008, 06:53 AM
  2. Select Graph with a Combo Box
    By Tnesper in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-25-2008, 03:06 PM
  3. How to select one of three lists for a combo box?
    By Ingeniero1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-16-2006, 02:33 PM
  4. [SOLVED] Select Method from Combo Box
    By bw in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-25-2005, 07:05 PM
  5. [SOLVED] How do I set up a combo box to select one value but pas an other .
    By exkiller in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-04-2005, 04:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1