Question
Need help writing VBA code for the following. 1) Write a function named areEqual. It should accept two arrays of type Single , both of
Need help writing VBA code for the following.
1) Write a function named areEqual. It should accept two arrays of type Single, both of the same size, and it should return a boolean value indicating whether the two arrays are equal or not. It should return True if they are equal and False otherwise. For example, if you pass in the arrays (3,5,1) and (4,3,6) it should return False and the program should display a message indicating that two arrays are not equal.
2) Write a subroutine named TestMyFunctions that declares the two arrays you can hardcode the values in) and calls your arrayEqual function and displays the results. Write the results out to a worksheet cell. Your function should test that the two arrays have the same number of elements.
Step 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