Posted 8 September 2017, 1:22 pm EST
We have a spread with data selected via a combo box which could be implemented using the MultiColumnComboBoxCellType. The problem is that the items list can number in the thousands when the combo box is dropped. To help minimize this, what I would like to do is mimic a menu and submenu flyout type situation where when the user hovered over a given line in the combo box, other items would be displayed like a submenu to the right. Hopefully the example below helps to give the idea. In the second example, when the user hovered over Item2, then the respective colors would be displayed like submenu flyouts. If instead, Item1 was selected then Red, Green, Yellow, Blue would be displayed instead beginning immediately to the Right of Item1.
Is this even possible? If so, how would one go about starting something like this? Thanks in advance for any ideas and/or suggestions!