VBA - Button to go a specific sheet depending on dropdown list

[akshay0880]

Hey Guys, I'm quite a newbie on this. So, I need button when I click, it will go a specific worksheet (within same workbook) depending on a dropdown list.
example: dropdown list say 'Freq Change'
when I click the button, it goes to the 'Freq Change' sheet

I will have multiple sheets like this and all the sheets will be hidden and I only want the selected sheets (in this case Freq Change) to unhide.
Sheet 1 (named Start) will be unhidden at all times and on which I will have the button + Dropdown list

Anyone can help me out please?

 

[mumps]

You actually don't need a button. Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your "Start" sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Change the range (in red) to match the cell that contains the drop down list. Close the code window to return to your sheet. Make a selection in the drop down list.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, Range("A1")) Is Nothing Then Exit Sub
    With Sheets(Target.Value)
        .Visible = True
        .Activate
    End With
End Sub

 

[akshay0880]

You actually don't need a button. Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your "Start" sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Change the range (in red) to match the cell that contains the drop down list. Close the code window to return to your sheet. Make a selection in the drop down list.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, Range("A1")) Is Nothing Then Exit Sub
    With Sheets(Target.Value)
        .Visible = True
        .Activate
    End With
End Sub

Hi, Thank you for the response.
However, I still need a button because I need to enter more things on the 'Start' sheet before I want to go to the other worksheets.
Basically, I will fill out some data including the dropdown list and when I am done, then I'd hit the "button" and that's when I want it to take me to the correct worksheets.

 

[mumps]

Place this macro in a regular code module (not the worksheet code module as the previous macro) and assign it to your button.

Sub ActivateSheet()
    With Sheets(Range("A1").Value)
        .Visible = True
        .Activate
    End With
End Sub

 

[akshay0880]

It worked! thank you very much!

 

[mumps]

You are very welcome.