Refedit Control for VSTO

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_vsto2005_ta/html/OfficeVSTOLanguageMigrationFromVBA.asp

The link above talks about a refedit control that can be used with VSTO. However, it does not appear to be implemented in VSNET 2005 Beta2? What is the status of such a refedit control?

[682 byte] By [JustinStarnes] at [2008-2-21]
# 1
Sorry to disappoint. VSTO does not provide refedit control.
MishaShneerson at 2007-9-8 > top of Msdn Tech,Visual Studio Tools for Office,Visual Studio Tools for Office...
# 2
Will a .net refedit control be provided (perhaps by the .net framework instead of vsto)? If not, current vba solutions will not be able to be migrated.
JustinStarnes at 2007-9-8 > top of Msdn Tech,Visual Studio Tools for Office,Visual Studio Tools for Office...
# 3
Refedit control won't be provided.
The best way in this situation to allow user to input range is by using Excel.Application.InputBox method. The following code has worked for me:

namespace ExcelWorkbook1

{

public partial class Sheet1

{

private void Sheet1_Startup(object sender, System.EventArgs e)

{

Excel.Range rr = this.Application.InputBox("Some Prompt", "Some title", missing, missing, missing, missing, missing, 8) as Excel.Range;

MessageBox.Show(rr.get_Address(missing, missing, Excel.XlReferenceStyle.xlA1, missing, missing).ToString());

}

}

MishaShneerson at 2007-9-8 > top of Msdn Tech,Visual Studio Tools for Office,Visual Studio Tools for Office...
# 4

Unfortunately, I need to have the user select multiple ranges from the same form without prompting the user for each one (as there could be 10-15 selections). Why will there not be a .NET Refedit Control?

JustinStarnes at 2007-9-8 > top of Msdn Tech,Visual Studio Tools for Office,Visual Studio Tools for Office...
# 5
RefEdit control is very tightly integrated into Excel and does not allow hosting in anywhere but in Excel's User Forms.
MishaShneerson at 2007-9-8 > top of Msdn Tech,Visual Studio Tools for Office,Visual Studio Tools for Office...
# 6
Hi Justin,

I was just going thru this forum & found that you also had same problem
which I am having now.

Have you found any alternative for Refedit Control to use in VB .net com addin?

Thanks & Regards,

Ajay

AjayPanhale at 2007-9-8 > top of Msdn Tech,Visual Studio Tools for Office,Visual Studio Tools for Office...
# 7

This is totally ridiculous, that some solution is not provided for via VSTO, VSTA or .NET. This totally disables any possibility of me moving any of my VBA projects out of the dark ages.

Since MS seems to ignore this need, has there been in third party solutions to refedit.

gsbraun at 2007-9-8 > top of Msdn Tech,Visual Studio Tools for Office,Visual Studio Tools for Office...