Is it possible to equation editor with VBA in excel 2010

Asked By 10 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 0 points N/A #198408

Is it possible to equation editor with VBA in excel 2010

qa-featured

Hi Zubin,

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
 
OLE Object
 
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, _
        DisplayAsIcon:=False).Activate
 
Using OLEObjectCollections, you can access objects like below,
ActiveSheet.OLEObjects.Item(1)
 
Let me know if this helps.

Related Questions