Results 1 to 11 of 11

Creating a drop down menu to select a sheet

Threaded View

  1. #1
    Registered User
    Join Date
    03-19-2015
    Location
    Newcastle, England
    MS-Off Ver
    365
    Posts
    33

    Creating a drop down menu to select a sheet

    Hi, I am looking for a solution to have a drop down menu that selects a certain sheet within my spreadsheet. Please bare with me as my knowledge of Excel is fairly basic.
    I have designed a spreadsheet to document the monthly checks of the work vans at the request of the boss.
    I'm currently using click buttons to link to the relevant sheet. Here is the current setup of it:
    \1

    These are the macros being used:
    Sub Menu()
        Sheets("Menu").Select
    End Sub
    Sub BlankForms()
        Sheets("Blank Forms").Select
    End Sub
    Sub June2016()
        Sheets("Jun16").Select
    End Sub
    Sub July2016()
        Sheets("Jul16").Select
    End Sub
    Sub August2016()
        Sheets("Aug16").Select
    End Sub
    Sub September2016()
        Sheets("Sept16").Select
    End Sub
    Sub October2016()
        Sheets("Oct16").Select
    End Sub
    Sub November2016()
        Sheets("Nov16").Select
    End Sub
    Sub December2016()
        Sheets("Dec16").Select
    End Sub
    Sub January2017()
        Sheets("Jan17").Select
    End Sub
    Sub February2017()
        Sheets("Feb17").Select
    End Sub
    Sub SaveWorkBook()
        ActiveWorkbook.Save
    End Sub
    Sub ExitExcel()
        Application.Quit
    End Sub
    Instead I'm looking for a drop down menu so that I have one per year e.g. 2016, 2017 etc then when I click on that it it gives the months so that when I click on it it takes me to the relevant sheet.
    It would be great if it automatically added any new sheets I created.
    I'm using windows 7 and Excel 2007 if it makes a difference.
    Any help is greatly appreciated Thanks.
    Last edited by digitised; 01-23-2017 at 08:28 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Select from a drop down menu using VBA
    By Johnnyv015 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-18-2014, 02:55 PM
  2. Replies: 1
    Last Post: 02-07-2013, 11:03 AM
  3. select a sheet from a drop down menu and move the row in the selected sheet
    By AlienPump in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-27-2012, 02:21 PM
  4. Creating a Drop Down Menu
    By JoeHan in forum Excel General
    Replies: 5
    Last Post: 11-29-2011, 11:29 AM
  5. Creating a drop down menu
    By djt in forum Excel General
    Replies: 3
    Last Post: 11-21-2009, 04:54 PM
  6. Creating Personal Menu Drop Down
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2009, 10:25 PM
  7. select multiple items from drop-down menu
    By jcavigli in forum Excel General
    Replies: 2
    Last Post: 05-25-2008, 11:50 AM

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