![Excel Excel](http://ldcss.s3-website-us-east-1.amazonaws.com/cms/asset/image/3D-Animation.jpg1483692064.jpg)
MS Office 365 for Mac, Excel 15.33 Posts 2. Check a column for text, then return corresponding cell's value Hi. Check a column for text, then return corresponding cell's value You would do it like this, assuming that the names match exactly. In B1 of sheet 2.
I am coding VBA in excel, which attempts to open and save a copy of a Powerpoint file, then add a textbox to a slide. Run in a Mac environment, the below code succeeds in opening and saving the ppt file, but on the With statement where it tries to call the AddTextbox method, it causes the Powerpoint Application to crash. (EXCBADACCESS error) I have no problem opening Powerpoint files and it crashes only when I ran this code. My suspicion is either the Shapes.AddTextbox method or some of its parameters are not supported, but I couldn't find relevant information/ reference on the internet. Many thanks if someone can shed light on this.
In addition, in the view that VBA is not as well-supported in Mac vs in Windows, is there other alternatives to Powerpoint automation (say Applescript)? This is more a comment than an answer, but comment formatting would make a hash of it, so here we are.
![Excel 15.33 For Mac Excel 15.33 For Mac](/uploads/1/2/5/4/125468416/606367250.gif)
First, I'd change Public Const COVERSLIDE = 3 to Public Const COVERSLIDE as Long = 3 It's generally best to TELL vba what you want rather than letting it guess. In this case, it shouldn't make any difference, but there are some strange bugs running around under the covers in Mac VBA. I'd also verify that Mac Excel (in the version you're running) actually does have an Application.InchesToPoints method. If not, it's simple enough to multiply your inches values by 72 when you add the text box. Finally, ppAlignRight is a PowerPoint constant, not an Office-wide or Excel constant, so it won't be defined, and in fact, should cause an error when you compile your code in the IDE (always a good idea before trying to run it). Either define it as: Public Const ppAlignRight as Long = 3 or use 3 instead of ppAlignRight in your code.