excel vba project, please explain it with Screenshots. Prepare a userform where the input fields are O
excel vba project, please explain it with Screenshots.
Prepare a userform where the input fields are
O
First Name (text)
O
Last Name (text)
O
Student No (unique number)
O
GPA (decimal number between 0.00 and 4.00)
O
Number of Credits Taken (integer between 0 and 150)
In the form there should be Save Data, Close Form buttons
Prepare a second form (reachable from the first form) where
O
there are summarizing fields where you calculate the min/max/average GPA of the class
room.
O
It should also show the top 3 students ranked with respect to their GPA
O
You can display the number of credits taken by a student when you enter the student no
(so there will be a field where you enter student no. And when you click it, it should
display the credits of the corresponding student)
Fill with at least 10 student data (you can randomly give numbers and names...)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images
