tips on using a button vs dropdown

I have a dropdown that list the names of spreadsheets stored in a tab (sheet 2). Once the name is selected in launches to that sheet. I would like to not assign a macro to the dropdown and assign it to the button to control when it launches. What are your suggestions to do this?

this is what i am currently using for my code:

Sub DropDown_Change()
    With ActiveSheet.DropDowns("Drop Down 1")
        If .ListIndex > 0 Then
            Application.Goto Sheets(.List(.ListIndex)).Range("A1")
        End If
    End With
End Sub

Open in new window

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kanti PrasadCommented:

If a user does not need to know all the choices in your list of data then using drop down is fine. Say like a like California or New York and they can select one state from all those choices but they need not know what are other states missing etc.

You use radio buttons when you need the user to see all the alternatives and then make a decision which one to selects.

Rule of thumb: If it's a long list or the alternatives aren't that important, use a drop down. So it is on what data you have in that list.

If you are looking for the code just let us know.
wiredemc12Author Commented:
Thanks for the points.
I have a long list of data to include in the drop down.
I was looking for code as well.
I think i will be using the
With ActiveSheet.Shapes("Button 2")
byundtMechanical EngineerCommented:
There are two types of command buttons that you can put on a worksheet: ActiveX and Forms controls. In addition, you can use a shape object as a button. We can't suggest the complete code for you button unless we know exactly what you implemented. The best way of communicating that is to post the workbook.

Assuming that you have successfully gotten a macro to execute when you click your button, the code that needs to run in it is the same as you had for your dropdown. Delete the code for the dropdown, and put these statements in the your command button macro:
    With ActiveSheet.DropDowns("Drop Down 1")
        If .ListIndex > 0 Then
            Application.Goto Sheets(.List(.ListIndex)).Range("A1")
        End If
    End With

Open in new window

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
wiredemc12Author Commented:
Just as simple as reassigning the macro.... i didnt even think about that. Thanks for your help.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.