Anyone Familiar With Excel VBA?

December 1, 2008
By

I’ve got a problem in my VBA editor that I haven’t been able to resolve using all the power of Google…

The Refedit control, in the toolbox bottom-left is unavailable to me, however all of the other controls are available, and user forms created with RefEdit controls function properly. When I try to use it, I get the following error message, I’m wondering if anyone of my 6 readers knows how to fix it?

I’ve tried a few things, including

Run | “c:\program files\Microsoft Office\OFFICE11\EXCEL.EXE” /regserver, to no avail.

This is the only VBA control that I can’t use, however, if I go into an existing UserForm, I can copy & paste to create additional RefEdit controls. I have not tested this process for functionality, since I don’t want to bust any of my existing Add-ins, all of which I have used frequently for at least a month, and none of which have been updated in any manner, recently.

I am running a registered, licensed version of Microsoft Office and Excel 2003.

If any other information would be relevant, I can post it in comments.

6 Responses to Anyone Familiar With Excel VBA?

  1. Jeff Molby on December 1, 2008 at 9:59 pm

    Try

    Run | “c:\program files\Microsoft Office\OFFICE11\Refedit.dll” /regserver

    or

    Run | regsvr32 “c:\program files\Microsoft Office\OFFICE11\Refedit.dll”

    If neither works, it could be because the dll file is in a different folder. If so, search for it and change the paths accordingly

    You may also want to try unregistering it first.

    Run | regsvr32 /u “c:\program files\Microsoft Office\OFFICE11\Refedit.dll”

  2. David Z on December 1, 2008 at 10:54 pm

    thanks but no dice… registration appears successful, but the regsvr32 /u command says i’m “unable to register…” or something. The file is in the correct folder location. hmmmm

  3. Jeff Molby on December 1, 2008 at 11:23 pm

    Was the workbook created in Excel 2003 or was it created in 2007 using the 2003 format?

    If you haven’t already,try creating a brand new workbook and adding a refedit to it. Same problem?

    Which Excel service pack?
    WinXP I presume?
    When was the last time you successfully used a Refedit?

    Consider running through the “repair” option of the Office setup wizard.

    Also, try opening the VBA editor and click Tools, References. If Refedit.dll isn’t listed, try adding it.

  4. David Z on December 1, 2008 at 11:55 pm

    Workbook was created in 2003. I noticed this problem, now that I think about it, shortly after a few crashes as a result of opening an .xlsx (I think 2007 version) that stalled in the conversion process.

    I am able to successfully use add-ins containing RefEdits, I just can’t create them. It has probably been more than a month since I last tried to insert one into a UserForm. In the toolbox, on hover, it says “unknown”.

    I’ve tried all combinations of Tools|References|RefEdit Control (checked and unchecked), etc…

    I think this is on SP2 or SP3 for XP. Not positive.

  5. David Z on December 2, 2008 at 12:20 am

    Jeff- thanks for the help. I tried everything above to no avail, but finally got it with the “repair” option in Setup.

    Sometimes, it’s the easy solution, which is always the one I overlook.

  6. Jeff Molby on December 2, 2008 at 1:08 am

    You’re welcome. Keep up the good work.

    BTW, I usually try the “easy” solution last because it’s often a brute-force fix that’s likely to cause as many problems as it fixes. Especially when you make frequent use of third party software.

Meta

Blogroll