Is it possible to equation editor with VBA in excel 2010

Asked By zubin lennon 10 points N/A Posted 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.

• Status: Open
• Question Views: 2351
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Anonymous questions

Answered By Munguia Roya 0 points N/A #198408

Is it possible to equation editor with VBA in excel 2010

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

 

 

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.

About Munguia Roya

Questions
2

Answers
12

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 02/20/2013
• Question Category: Anonymous questions