User Defined Function

[monty01]

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.

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I will add them this time, but take the ime to read the Forum Rules.

[Richard Buttrey]

Hi,

Assuming the function is in a cell as a string, and you may have to impose some discipline on the formatting, you could either have some helper cells, (probably hidden) to slice it up with the string slicing functions, then read each of these cell elements into VBA Variables and rebuild the f00 function.

Alternatively read the single cell string function into VBA and slice it up and reconstitute it as a maths function within VBA.

HTH

[shg]

I would like for the user to enter the function in a specific cell,

Maybe like this:

Please Login or Register  to view this content.