Benefits: - Faster way to finish the job and makes it easy for the student to register for classes without meeting with an academic advisor.
- Easy classes entry for the advisor by just typing in the excel sheet.
Description: - Provide a worksheet including classes, pre-requisite, name of student, UID, and classes taken entered by the student using excel.
Methodology: - using codes from the book to generate the Userform.
- Connecting the worksheet to the Userform.
- Define the relationship between classes and pre-requisite.
- Selecting classes and showing each pre-requisite in a message box.
Codes: are in the attachment.
Next semester:
- Improve the project to make it provisional.
- Styling
- Satisfying user needs for small details.
Look at the project attached to be more familiar and how it is working.
Attachment:- copy_of_iseproject.xlsm