Active X Button to Look into List Box and go to worksheet

[RPickering2]

After weeks on this very helpful website I am one part away from finishing my excel project.
This seems to be the easiest one but I can't seem to make it work. This is how my excel workbook works.

1. Users enters a name in Select Student Sheet.
2. User press "Add" button
3. This adds the template of 18 worksheets. (17 are hidden. The template sheet that is giving me problems is "student template" one.)
4. Each one of the sheets is then named accordantly by the macro.

Now this is the problem. Since The "Student template" allows the user to see the marking sheets of a user and select them then go to the correct sheet when you press the "GO" button on the "Student Template" whereas now the "GO" button no longer goes to the sheet and has become unresponsive.
The code for the "GO" button must be done on the "Student template" or it won't copy over when you add a new student.

[davesexcel]

In design mode, double click on the "GO" button, you will see that there is no code in that button's sub(), so nothing is going to happen when you click it.

[jaslake]

Hi RPickering2

We worked on this previously. Somehow, somewhere you lost some code. These lines of code are missing from your current iteration

Please Login or Register  to view this content.

Check previous versions of your project. The code appeared to work.

[RPickering2]

Oh sorry ^ Thanks once again for the help.