Uncategorized

Solving Excel VBA micro question

Using VBA from excel what is a simple algorithm using a FOR statement to find the value of f by using the equation below. Construct an interface like the one below and use those values given as input. Possible values of f range from 0.008 to 0.1. Round the final answer to five decimal places to the right of the decimal and present in a message box.
The graph below shows the response of the left and right sides of the equation. Hopefully, this will help you develop a strategy to exit the For statement.
Please use only VBA Excel loops to answer the question, Please show coding. Kept getting errors in my coding trying to find where my error is or if it’s wrong all together.

Leave a Reply

Your email address will not be published. Required fields are marked *