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.
Bookmarks