Hello all! I downloaded code to run the "bisection method" on a continuous function. However, it is hard coded for a specific equation. Is there any way that i can use a cell for a user to input his/her function f(x) = xxxxxx, then run the sub to iterate for the root?
Here is an example of how the function is hard coded (see bold at the bottom). This is a little user unfriendly, because the person using this would have to open VBE and manually change the function each time. I would like for the user to enter the function in a specific cell, and then run the sub. How can i pass the function input by a user into a cell to the sub? Thanks in advance!
Please Login or Register to view this content.
Bookmarks