Evaluate function in VBA

I have written a user-defined function to evaluate text that looks like a formula. In the simple example attached:

Cell named length has value 2
Cell named breadth has value 3
Cell named height has value 5

Cell D5 has text 'Length * Breadth' then Cell named Area calculates using my User Defined Function as Eval(D5)

Similarly I get the value for Volume as Area * Height

The formula is:

Please Login or Register  to view this content.

In Excel 2003 all worked fine. In Excel 2007 there seems to be a problem with the automatic calculation process. Opening the spreadsheet the Volume does not calculate, instead it shows #NAME. Editing a cell forces the calculation to be done. Then if I edit the length the area is calculated, but not the volume. Excel is re-calculating once, but not the two times that is needed.

Any thoughts on how to get the calculation correct?

Thanks
Keith

Welcome to the forum.

You could make your function less ambiguous and more versatile:

Please Login or Register  to view this content.

Then you can also do,

=eval("length*height")

Please take a few minutes to read the forum rules, and then edit your post to add code tags.