Macro to change worksheets

[fodeps]

I have a spreadsheet that has several different sheets and a number of checkboxes to indicate selections.attached is a simple workbook as an example.
I would liketo write a macro that will allow me to select a class of my choice,in a particular district and hit a go button that will automatically take me to the seected sheet in the workbook.
thanking you in advance
ohlori.

[Paul]

Hi Fodeps,

Perhaps this code will help you out (it requires that the values in the drop-down list match your sheet names EXACTLY.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("H3")) Is Nothing Then
        Sheets(Range("H3").Value).Activate
    End If
End Sub

If they don't match, you'd have to alter the code so that it selects the correct sheet.