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

Activation of the sheet generates the error when it tries to access the text value of a RefEdit control. When I stop the debugger and check the references, it shows that RefEdit control is missing.

The location it refers to appears to be incorrect: <userdir>:tmp:REFEDIT.DLL. The spreadsheet was created using Excel for Windows.

Unfortunately it is a proprietary spreadsheet, so I cannot post the code.

Answer 3

I opened a new, blank workbook in Excel 2011. I inserted a new userform (Userform1)

In the Toolbox the RefEdit control is available. There was no need to create a reference. I used the example in this article on how to use the RefEdit control. 

http://support.microsoft.com/kb/213776

I used the example code except for the unload command, which I changed to 

Unload UserForm1

instead of Unload Me

I inserted a module to run the form:

Sub RunMyForm()

Load UserForm1

UserForm1.Show

End Sub

The RefEdit control worked exactly as expected. I was able to select a range of cells, which displayed properly in the RefEdit control, and they were formatted as expected.

So you don't create a reference to use a RefEdit control. It is there by default. RefEdit is not an Active-X control, it is a standard control in Excel. My test indicates it is working as expected. 

The 424 error code indicates that an object that is required was not specified or found. If you can post the line of code that threw the error (and anything relevant to what the code is attempting to do) we might be able to offer more assistance. 

At the moment, I don't think the RefEdit control is the cause of the code error.

Answer 4

According to the list, RefEdit is actually missing. Unfortunately, adding the reference gives another error message "Run-time error '424'".