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