Creating a GO button for a drop-down list

[audiudo]

Hello, I have created a drop-down list using the validation tool in Excel 2007. The list is not hyperlinked to pages within the sheet.

I want to add a GO button to take you to the page within the workbook from the drop-down list.

I added the button but I don't know how to add the coding for the button to correspond to the list selection, or what the coding might be.

Thank you in advance for your help.

 

[nigelk]

Probably something like this ( The code is in a regular module):

Assuming your validation is in cell A2

Sub GotoSheet()

Dim ShtName As String

ShtName = Range("A2").Value

Sheets(ShtName).Select

End Sub

Just change the ref to suit.

Nigel.