Using Excel equation builder in VBA

[Mutak]

Hello,
Is it possible to use Excel VBA to build equations? When I say equations, I mean this:

https://i.ytimg.com/vi/mAujt1Fs0VY/maxresdefault.jpg

I've tried recording a macro but it doesn't help. I was trying to see how the code for the fraction 2/3 would look like, but the macro code just reads "?2?3?".
Any help would be appreciated.

[shg]

I don't believe the equation editor is exposed in VBA. It's a third-party product; the smaller brother of Design Science's MathType.

[CAntosh]

I'm not sure equation builder will cooperate with vba very well, but if you can sort out the math/coding on your own, you can definitely program new functions into excel. A quick example would be a quadratic formula UDF:

Please Login or Register  to view this content.

=QuadraticFunc(1,6,8) representing x^2 + 6x + 8 returns a value of "-2 or -4"

[Kenneth Hobson]

A kludge would be to use a symbol(s). e.g.

Please Login or Register  to view this content.

Another method might be to copy/paste a pre-created one.

[Mutak]

The above code works well as a substitute. How would you go on with these symbols if you wanted to have parts of the equation which are not in a fraction, e.g. 5+ 2/3 +4?

[Kenneth Hobson]

String concatenation:

Please Login or Register  to view this content.

[Mutak]

I meant it to look more like this:
Izrezak.JPG