Answered step by step
Verified Expert Solution
Question
1 Approved Answer
CAN I have all the code for VBA using excel. (b) Figure 5 contain a VBA module that will output a message indicating your total
CAN I have all the code for VBA using excel.
(b) Figure 5 contain a VBA module that will output a message indicating your total score and your grade for the course based on your inputs in the cells C3:05. If the total score is greater or equal to 80, then your grade is A. If the total score is greater or equal to 65 but less than 80, then your grade is B. If the total score is greater or equal to 50 but less than 65, then your grade is C. If your total score is less than 50, then you fail the course. A E F 1 2 3 Your Grade Assessments Test 1 Test 2 Final Exam Marks 10 8 20 s Microsoft Excel 8 9 Your total score is 38, and you FAILED the course! 10 11 12 13 OK 14 A D E F 1 2 3 4 Your Grade Assessments Marks Test 1 20 Test 2 18 Final Exam 30 5 6 7 Microsoft Excel Your total score is 68, and you PASSED the course with grade B! 9 10 11 12 13 OK Figure 5 Write the codes for a Subroutine with the name YourGrade to output a message indicating your total score and gradeStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started