Cell selector window RRS feed

  • Question

  • Please help me to show range selector, which will show a popup window, the value in the window changes whenever user changes cell selection.

    Tuesday, October 15, 2013 11:59 AM


  • Hi Rosh,

    Thank you for posting in MSDN forum.

    According to your description, you want to show a popup window to select Excel range.
    I wrote a VSTO sample with C# for your reference:

       Excel.Range range=Globals.ThisAddIn.Application.InputBox("Please choose a range!", "Please choose a range!", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, 8);
                range.Value = "Hello";

    You can get more information from article below:

    _Application.InputBox method

    Best regards


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Marked as answer by Rosh Mohan Friday, October 18, 2013 7:54 PM
    Thursday, October 17, 2013 6:38 AM