V Objects in Excel VBA(20 Points)- Given a grade sheet table, use VBA to perform

Question

V Objects in Excel VBA(20 Points)- Given a grade sheet table, use VBA to perform the following actions (Type the code in a assign every requirement a separate button) module and Student Name Student ID Quiz 1 Benson, Mike Carden, Joey Finkle, Sabrina Gellar, Veronica Hodge, Sabastian Blue 2 3 Yellow Randomly generate Quiz 1 marks according to a uniform distribution between 0 and 10 (You are not required to use Autofill method used in class today). Change the font of the headings to "Times New Roman", 14 points, bold face, and red color Give each column of the table its own color (colors are being defined in the last row of each column). d Add a border around the headings. The border's color should be red and its thickness medium ve do

Explanation / Answer

Solution:

a) Function UniformRandomNumber(Low As Single, High As Single)

        UniformRandomNumber = Rnd * (High - Low + 1) + Low
        
End Function

Function call as below:

UniformRandomNumber(0, 10)

b) Please include the below snippet to your coding to get the font style changed.

With object.Style

        .fontFamily = "Times New Roman"

        .fontsize = "14pt"

        .fontcolor = "red"

        .fontWeight = "bold"

    End With

Related Questions

Navigate

• Browse (All)
• Browse V
• Subjects

---

---

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