Hi all,
Created an ActiveX ComboBox with search suggestions that automatically refilters ("shrinks") as the user types (KeyUp event). The ComboBox is "floating" and sizes/positions itself depending on whether or not the ActiveCell intersects certain rows/columns.
I've noticed that whenever the ComboBox is repositioned and I call the .DropDown method, the DropDown list appears where the ComboBox *used* to be and not at it's current location. I've tried to workaround this by selecting the last active cell and then reactivating the ComboBox but this doesn't always appear to correct the problem and results in a lot of "flickering" since it's deactivating/reactivating the ComboBox with every keystroke (because it fires on the KeyUp event).
Additionally, sometimes the ListItems (including the scroll bar) are all squashed into a single row of the ComboBox. Clicking the drop down button again correctly places the list and populates the list to the correct .ListRows.
Is there a cleaner method to force a redraw of the ComboBox object? E.g., maybe calling the ComboBox_DropButtonClick event from a module?
Created an ActiveX ComboBox with search suggestions that automatically refilters ("shrinks") as the user types (KeyUp event). The ComboBox is "floating" and sizes/positions itself depending on whether or not the ActiveCell intersects certain rows/columns.
I've noticed that whenever the ComboBox is repositioned and I call the .DropDown method, the DropDown list appears where the ComboBox *used* to be and not at it's current location. I've tried to workaround this by selecting the last active cell and then reactivating the ComboBox but this doesn't always appear to correct the problem and results in a lot of "flickering" since it's deactivating/reactivating the ComboBox with every keystroke (because it fires on the KeyUp event).
Additionally, sometimes the ListItems (including the scroll bar) are all squashed into a single row of the ComboBox. Clicking the drop down button again correctly places the list and populates the list to the correct .ListRows.
Is there a cleaner method to force a redraw of the ComboBox object? E.g., maybe calling the ComboBox_DropButtonClick event from a module?
Attachments
Last edited: