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

Answer this question

Refedit Control for VSTO

Charles4
RefEdit control is very tightly integrated into Excel and does not allow hosting in anywhere but in Excel's User Forms.
leuriat
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
Sabroni

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.
Heinz
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
Jackson Gomes
Has anyone on the list found a workaround / solution / alternative

As gsbraun was noting, not having refedit is completely unacceptable. From Dec 2006 to now, perhaps someone has figured out a solution

Any help pointers are very appreciated

Juan C. (jcmendez@gmail.com)
Marnik Van Hileghem
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< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

{

      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());

            }

}
Nigel Batten
Sorry to disappoint. VSTO does not provide refedit control.
lenyado
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.
Refedit Control for VSTO

Answer this question