I am working on a vba code.
I have a function in terms of x, say (x)^2 + x.
I want to find values of this function for different values of x, say from 1 to 5.
For that I am using a 'for next' loop.
For x = 1 To 5
fx(x,1) = (x)^2 + x
But problem is that, this is not the only function. I want these values for any other functions of 'x', say cos(x), etc.
And I want this function to be given by a user as a sting in terms of 'x' either as an input in a cell or as input in inputbox and then I want to use this in 'for next' loop.
This is like converting a string to function with variable as 'x'.
Please help me. How to do this.
Thank you in advance.