I have been experimentng with the Comctl32 Listbox control in the last few days. The final result looks good BUT there are two major limitations which I should mention upfront beofre getting too excited.
1- ListBoxes can only be added to MODAL UserFoms.
I have been looking for ways to overcome the weaknesses of the native Excel Data Validation lists and to make such DV lists more versatile by adding often sought functionalities sunch as the following:
A- Not being affected by the current worksheet zoom (specially when the worksheet...