Search code examples
exceluserform

"Unknown" control in Toolbox


Was working on a new project today when I noticed this "Unknown" control type in the toolbox - I haven't seen this before. Does anyone know what this is?

Unknown


Solution

  • This is the "RefEdit" control. When it's active, and using the mouse, it allows the user to select a cell, range of cells (by holding mouse or with Shift), or Multiple Ranges of Cells (with Ctrl). (arrow keys do not work). The selection can be on a different sheet to the one the control is on.

    It returns a string that represents the range selected, I.e.
    Sheet1!$A$1,
    Sheet1!$A$2:$B$2 or
    Sheet1!$A$1,Sheet1!$A$2:$B$2,Sheet1!$A$3:$C$3
    etc, respectively.

    bettersolutions.com has probably the most info I can find on this.

    As the user can type into this control, it Does Not necessarily return a Valid range!

    Interestingly, the "Unknown" control type tooltip is probably because of https://peltiertech.com/unspecified-painfully-frustrating-error/ due to apparent general RefEdit flakiness: https://peltiertech.com/refedit-control-alternative/