Results 1 to 4 of 4

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

Threaded View

RPickering2 Active X Button to Look into... 02-01-2011, 06:08 PM
davesexcel Re: Active X Button to Look... 02-01-2011, 09:02 PM
jaslake Re: Active X Button to Look... 02-02-2011, 02:14 AM
RPickering2 Re: Active X Button to Look... 02-02-2011, 07:26 AM
  1. #1
    Registered User
    Join Date
    01-17-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    60

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

    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.
    Attached Files Attached Files
    Last edited by RPickering2; 02-02-2011 at 07:37 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1