What is this drop down thing???

B

bmc126

New member
Joined
Aug 11, 2018
Messages
2
Reaction score
0
Points
0
Excel Version(s)
2010
I am looking to create a sheet that has a dropdown to change the month and years without creating many different sheets. Something like this: https://goo.gl/images/h42Y5U

Anyone can tell me what this is called or point me in the right direction would be super appreciated!

Thanks!
 
.
You will need to be more specific. The link takes the viewer to a transition web page. Then the final page has a number of Time Sheet examples for
various purposes.

Which time sheet are you referring to and what specific attribute of the time sheet is of interest ?
 
So sorry!

there is a drop down at the top of the spreadsheet where you select the month / year and the spreadsheet changes to the different months. I know how to create a drop down menu, but how do I format it so that I will change it to different month's sheet.
 
.
If I correctly understand your question .... here is one way :

Code: 
Option Explicit


Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("E1")) Is Nothing Then
        Select Case Range("E1")
            Case "Sheet 2": Macro1
            Case "Sheet 3": Macro2
            Case "Sheet 4": Macro3
        End Select
    End If
End Sub


Sub Macro1()
    Sheets("Sheet2").Activate
    Sheets("Sheet2").Range("A1").Select
End Sub


Sub Macro2()
    Sheets("Sheet3").Activate
    Sheets("Sheet3").Range("A1").Select
End Sub


Sub Macro3()
    Sheets("Sheet4").Activate
    Sheets("Sheet4").Range("A1").Select
End Sub

In the above example code, the drop down is located in E1
 

Attachments

  • Drop Down Sheets Menu.xlsm
    16.1 KB · Views: 8
You must log in or register to reply here.
Back
Top