(Solved) : Create Use User Defined Function 2 Marks Udf Sheet Setup Creating Using User Defined Funct Q29623857 . . .
Create and Use a User-Defined Function (2marks) – the udf sheet is setup for creating andusing a user-defined function. Steps:
In the Visual Basic Editor, in module1 there is afunction already created called SUMCOLOR for you to edit.This function is similar to one in the notes except that instead ofthe color being given to sum the cells, the color is retrieved fromthe color of the cell given in the second argument. (1 mark)
Use the function SUMCOLOR to create formulas for cellsF3:F5 that sum the cells that are orange, blue, and green.(1 mark)
Function SUMCOLOR(RangeToSum As Range, CellWithColor As Range)As Long
Dim colorId As Integer
Dim result As Long
Dim cell As Range
result = 0
‘ TODO: Fill in this method
SUMCOLOR = result
End Function
Expert Answer
Answer to Create Use User Defined Function 2 Marks Udf Sheet Setup Creating Using User Defined Funct Q29623857 . . .
OR