evaluate with strings and variables

[excelnovicehouston]

Hi,

I am try to do the following.

in excel I have a cell A1 = "IF(day>6, day+5, 6)"

i have a vba code

(ineq = the above IF equation)

function helpday(ineq)

day = sheet1.range("A5")
month = sheet1.range("A6")
helpday = evaluate(ineq)

End if


I want excel to evaluate this function, but it does not unless I do a replace(ineq, "day",day). however, I want the user to be able to change the equation from IF(day,x,y) to something like IF(month,x,y) and not have the code break without me adding a replace(month).... can excel do this?

many thanks for the help.

 

[Andrew Poulsom]

Why can't you just name A5 day and A6 month and enter the formula as a formula?

 

[excelnovicehouston]

can you elaborate?

i will likely be doing this routine in a for loop and so month and day would be passed into the function helpday as

helpday(month, day, ineq)

don't think it would be possible to construct it this way?

 

[Andrew Poulsom]

Yes, if you must use a custom function you should pass it all the necessary arguments. But that won't help you with your Evaluate problem.