Equations in excel

[Bob]

Hi all:

I was wondering if in excel macro, I can have my user input an equation in a
cell as either text or formula (for example "x^2+3*x+6"), and in my macro
read this text, and evaluate the function, and put the result in a variable,
for example y. I need this to process Newton-raphson method for any
inputted function. Thanks for your help.

Bob

 

[Gary''s Student]

The user enters the following text in A1:

x^2+3*x+6

this macro:

Sub marine()
Dim s As String
Dim v As Variant
s = Range("A1").Value
s = Replace(s, "x", ".1234")
y = Evaluate(s)
MsgBox (y)
End Sub

1. gets the expression
2. puts in some value for x
3. evalues the expression and places the result in the variable y
4. the result is also output ( you may not need this)

 

[Bob]

Thank you.

The user enters the following text in A1:

x^2+3*x+6

this macro:

Sub marine()
Dim s As String
Dim v As Variant
s = Range("A1").Value
s = Replace(s, "x", ".1234")
y = Evaluate(s)
MsgBox (y)
End Sub

1. gets the expression
2. puts in some value for x
3. evalues the expression and places the result in the variable y
4. the result is also output ( you may not need this)