N/APosted on - 02/06/2013
Hi, I adhere applied the equation object editor in Word 2007 beta with VBA.
Now is it possible in excel 2010?
I tested to paste in excel but it doesn't work.
Is it possible to equation editor with VBA in excel 2010
You need to add OLE Object to Excel before accessing the Equation Editor.
You can insert OLE object from Insert Menu. Insert > Object > Microsoft Equation 3.0
If you don't have Equation Editor, You can install it from the MSDN Website.
You can add equation using
ActiveSheet.OLEObjects.Add(ClassType:="Equation.3", Link:=False, _
Using OLEObjectCollections, you can access objects like below,
Let me know if this helps.