+ Reply to Thread
Results 1 to 3 of 3

controlling multipage tabs

  1. #1
    Registered User
    Join Date
    08-15-2006
    Location
    Gloucester, England
    Posts
    19

    controlling multipage tabs

    Hi all,
    I am trying to create a user form that allows trainers to input course feedback data onto a worksheet that then creates tables and statistics for management.
    the worksheet itself was populated by a lead trainer on receipt of the course data, feedback results etc. this then calculates the charts. that bit works fine as I don't want to touch that as yet.
    My problem is the following I have several different courses that come up on a combobox. this, when submitted to the worksheet puts the data into the correct cell. that bit works fine. What I want to do is have the course combobox control which tab to display on the multipage control.

    i.e. courses are for example:
    management
    2 day HR
    Logisitics

    All courses have different feedback questions.

    Therefore if the management course was selected then on the multipage tab the management tab would be uppermost so that the results could be populated on that form.

    I hope I've made myself clear.

    WINXP PRO excel 2003. complete newbie doing this , first time I have ever used VBA or indeed any other programming language, but getting there.

    any help would be most appreciated.

    Alan.

  2. #2
    Valued Forum Contributor Charles's Avatar
    Join Date
    02-10-2004
    Location
    Biloxi
    MS-Off Ver
    Windows 7, Excel 2003,2007 & Mac2011
    Posts
    845
    Hi,

    The following code may help you get started.


    Please Login or Register  to view this content.
    Charles

    There are other ways to do this, this is but 1 !
    Be Sure you thank those who helped.
    IF YOU'RE SATISFIED BY ANY MEMBERS RESPONSE TO YOUR ISSUE PLEASE USE THE STAR ICON AT THE BOTTOM LEFT OF THE POST UNDER THEIR NAME.

  3. #3
    Registered User
    Join Date
    08-15-2006
    Location
    Gloucester, England
    Posts
    19

    thankyou, thankyou

    That is just what I was looking for. works a treat, you are now on my christmas card list.
    thanks again

    Alan

+ Reply to Thread

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