With VBA complete the following question \'Question 8. \'List three methods for

Question

With VBA complete the following question

'Question 8.
'List three methods for running/execution a VBA Sub procedure from another procedure.
' Which method would be most suitable when users have to determine (at runtime) the name of VBA script to run?
Sub CallaFunction()
Dim Score1 As Integer, Score2 As Integer, valMax As Integer, AveScore As Double
AveScore = AverageScore(Score1, Score2)
' Modify the script to call a Function named MaxScore that 'determines the maximum score (i.e., maximum of Score1, and Score2).
'(You will need to create a MaxScore function). -- Refer to function 'AverageScore' below as a guide.
' Display the maximum Score and the Average Score in a MsgBox.

End Sub

Explanation / Answer

Function AverageScore(Score1, Score2)
AverageScore = (Score1 + Score2) / 2
End Function

Excel File:

https://docs.google.com/spreadsheets/d/1VvKepH6BjtK4bpWjZkNAndom_xAXHfqFAmbM6Fd2uRk/edit?usp=sharing

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

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