Using excel developer tab and visual basic The final product will allow students

Question

Using excel developer tab and visual basic

The final product will allow students to interact with the 2016 BS in ISE curriculum guide, to help both continuing and prospective students understand basic course content and prerequisite requirements. It will also provide a list of potential courses for which a student may enroll based upon the courses they have already successfully completed.

Using student input on which courses they have successfully completed, a list of potential courses for which they have met the prerequisites, but have not yet taken will be listed. This (along with requirement #3) is meant to assist students in planning their future semester schedules. The list should be generated based upon fall/spring/summer projected course offerings.

I just need help with how to do the prerequisites I was planning to do check boxes but I don't know.

Explanation / Answer

To implement this, the basic idea is: First display all student course details in excel sheet. Then hide all columns and display only column with student ID matches. Remaning all will hide...

Private Sub CommandButton1_Click()
   Dim studentID As String
   'Reading student ID
   studentID = Application.InputBox("Enter your student ID:", "Input Box Text", Type:=1)
   If studentID = 1 Then
   '
   ' display student ID->1 details
   '
   Columns("B:C").Hidden = True
   ElseIf studentID = 2 Then
   '
   ' display student ID->2 details
   '
   Columns("A:C").Hidden = True
   ElseIf studentID = 3 Then
   '
   ' display student ID->3 details
   '
   Columns("A:B").Hidden = True
   End If
End Sub
  
  
''creating main button to open input prompt
=EMBED("Forms.CommandButton.1";"")

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.