Macro to change worksheets

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.

Hi Fodeps,

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

Please Login or Register  to view this content.

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