I am building a VB6 COM Addin for MS Excel 2002 and would like the user to be able to select a spreadsheet range using Excel's RefEdit control on a VB form.

When I try and add the 'Ref Edit Control' from the components menu I get the error message: "Object library invalid or contains references to object definitions that could not be found".

Does anybody know how to make this control work using a VB6 COM Addin?

Does anybody have another work around for selecting & displaying multiple user selected ranges using a VB6 COM Addin?

Is VB6 the best place to build COM Addins or is VB.Net better?

Any help / advice would be appreciated.

Thanks,

Peter