Usage - Excel Render VBA

The main interface to this Excel Add-in is through the toolbar:

Each button performs the following tasks:

Button	Action
	Creates a graphical formatted equation for the formula within the current selected Cell. You can update a previously generated graphical equation, by selected either the source Excel Cell with the formula or the previous graphical equation. Either way, this tool will look for a new formula within the source Cell and update the equation as appropriate. If you have repositioned the graphical equation, then an updated to the equation will maintain this position. Note: If you move a formula Cell, then the link to the graphical equation will be broken.
	As above, except that the graphical equation is encapsulated within a box. This box is added within Excel, so the properties of the box (thickness, color, margins etc) can be change afterwards.
	This will erase the currently selected graphical equation, or graphical equation associated with a particular Excel Formula.
	This will erase all graphical equations generated by this Add-in.
	Help - which will bring you back to this page!

If you select multiple cells or previously formatted equations, then these buttons will cycle through each object (Cell or formatted equation) and execute the action required. Note: that to update a previously generated equation you can select either the graphical equation or the original call and press one of two equation rendering buttons.

This tool converts both Excel formulas and LaTeX equations, as detailed below:

Excel Formulas

Excel equations all start with an '=', e.g.

=A1+B2

=SUM(A1+B2)/SIN(x)

The add-in understands that these are Excel formulas and applies appropriate formatting to create the graphical equations. This includes making function names bold and cell references blue.

LaTeX Equations

If you prefer to write an equation in the LaTeX equation syntax then simply type the LaTeX equation directly into the cell and click either one of the equation formatting buttons, e.g.

\int_3^4 sin(x^2)

\sum_{n=1}^N \frac{a_n^2}{2}

For help with formulating the LaTeX code see our LaTeX Equation Editor.

Printing

The equations inserted into Excel and generated in a gif file format at 300dpi. This gives good resolution on most laser printers. For display on the screen, the equation is reduced to only 100dpi. If you enlarge the graphical equation (by scaling) then be aware that although it may look good on the screen, the printed quality will reduced.