Missing Ref Edit Control.

Question

In Office Excel 2011 for Mac I get an error 'Can't find project or library'. Tools->references shows 'MISSING: Ref Edit Control'. This appears to point at the wrong location. How can I fix this?

Thanks,

JdW

Answer 1

The refedit control, in this case, MAY be active-x. You will have to rewrite the macro to use conditional assembly, or run time platform determiniation to execute the proper Mac compatible code.

Answer 2

RefEdit is a standard Forms control, not an ActiveX control.

Much has been written about using the RefEdit control, and a Google search for "excel vba refedit" (without the quotes) will yield items reporting problems with using it.

Jon Peltier has a useful web page, Using RefEdit Controls in Excel Dialogs, at

http://peltiertech.com/WordPress/using-refedit-controls-in-excel-dialogs/

When I write Excel VBA on Windows (and subsequently test on the Mac), before I create an add-in, I now follow his advice: "To reduce the risk of RefEdit-related issues, you should uncheck the box in front of Ref Edit Control in the References dialog."

So, the original poster might be able to solve the problem by unchecking the Ref Edit Control reference and clicking OK.

-  Mike Middleton, www.TreePlan.com

Answer 3

RefEdit is an acticve-x control available with the windows version and not supported on the mac. you will have to rewrite the macro to use another approach instead of the refedit control.

Answer 4

I just installed MS Office for Mac this weekend. This was one of the first spreadsheets with extensive macros that I tried. It is the 30 day trial version.

Thanks,

JdW

Answer 5

Has Excel been working OK all along?  Is this a new problem?