This requires a code be written in VBA using excel developer. I could use help with this assignment. Could you also show that the code worked? My current code is giving me error messages.

Problem Statement: Write a single well-commented program to receive and store a flow of data, and to indicate if and when that data is out of range. Additional Requirements/Details: Your program should: Query the user for 10 data values, one at a time. (In practice, this user input would typically be replaced . ith a call to a sensor and the process would run continuously until a stopping criterion was reached.) Request the user enter numerical values above zero (assume it is single precision data type). If any value exceeds 100, use a message box to notify the user that there's a problem. For extra credit, sound an alarm when the message box comes up . . Log all input data values in a l-d array . In a second 1-d array, log a text description of the status for each input data value (for example, "AOK" or Above Range"). Note: For full credit we are only requiring you to populate the arrays, not print the arrays out anywhere. But you won't really know if your code is working unless you actually look at the results, so you will probably want to include for your own purpose putting those arrays into the Excel worksheet. o