Creating a VBA Program

[mhtoo2127]

Write a VBA program that will use the method of selected points (see the Engineering Topics document in the Lectures Folder on MyCourses, Slides 124-131) to solve for the m and b values in the selected equation. The program should ask the user which type of function they would like to fit (linear, exponential, or power), then ask the user to input the x and y coordinates for two data points to use for the method of selected points. The program will calculate the equation parameters (m and b), and display the fitted function in a dialog box.
Use the following data points (A and B) to test your program for the three cases shown
1) Linear function (points taken from a rectilinear graph): A(10, 60), B(35, 165)
2) Exponential function (points taken from a semi-log graph): A(1.5, 11), B(6, 175)
3) Power function (points taken from a log-log graph): A(15, 33), B(65, 470)

 

[Skrej]

I suspect your instructor wants to see your work, not what others internet people can do. Perhaps if you asked some more specific questions, versus just (apparently) asking someone to do what's clearly a class assignment? You'll learn more that way anyway.

 

[Michael M]

You also need to show us what you have done / achieved so far rowards completing this assignment.