User Form, Homework Help, VBA, will pay!!!

[sliollio]

If anyone can do this lab that is due Wednesday for me I will honestly paypal you $10. I know this is a breeze for most of you and I would typically try and knock it out myself but I have a Prob&Stats exam tomorrow and a Deterministic Exam Wednesday that I really need to focus on and have no time

COMP 3010/3
Lab Assignment 7

User Forms

1. Create a new Lab7_solution.xlsm file
2. Insert a UserForm in the VB Editor that will:
   1. Ask user to enter the following information: Year, Course Name, Course Number and Grade.
   2. Use a ComboBox for Year, ListBox for Grade and TextBox for all other information as shown in the figure below.
   3. Populate the ComboBox and ListBox with the UserForm_Iinitilaize event.

1. Once the user enters the information in UserForm, place all the information in the worksheet.

1. Ask the user whether he/she wants the grade point average (GPA) yearly/final?
2. Generate and display the GPA as required.
   1. For Yearly GPA, compute the GPA for Freshman, Sophomore, Junior and Senior
   2. For Final GPA, compute the total GPA.

Save your document as Lab7_ solution.xlsm and submit it to Canvas before the due date.

Instructions for Lab Assignments

1. Excel Worksheet functions should not be used in programming code, unless specified in the assignment.
2. Make sure that the correct file is uploaded to the Canvas, before the due date.

 

[jgreggain]

Not sure on the ethics behind this request, but your images didn't populate. You need to upload them to a cloud-based image service, and then link to them that way. Until you do that, nobody will be able to help you.

 

[sliollio]

(IMAGE 1)
http://res.cloudinary.com/dowvgkuhl/image/upload/v1415676092/pic2_cvxdpj.png

(IMAGE 2)
http://res.cloudinary.com/dowvgkuhl/image/upload/v1415676088/pic1_sekcrs.png

 

[sliollio]

Haha yea I feel bad just for asking, but I didn't want someone (if they chose to) to spend the time doing this and not get anything out of it!

 

[mikerickson]

The practice here, regarding homework, is that we don't do your homework.
But if you are stuck, you can ask a question and we will (hopefully) guide you to a solution.

In this situation, most would want to know what you have tried and what isn't working the way that you want.
Then we will offer suggestions that will help you learn to do the assignment yourself.

 

[sliollio]

Haven't tried anything at all:/ Don't have the time. This is taking a backseat to my 2 exams unfortunately, but I have a strong A in the class so if I get a zero on it, it's ok. Just wanted to see if anyone would/could help out.