Hi all,
Is there a way to add a search function to a Form Control ComboBox by using a VBA code? As it seems, such function does not originally exist within Excel. Basically, As illustrated in the image below, I need to search for a particular store (1500+ stores available).
E.g. If I start typing "Ocean Terminal Hon" it automatically suggest all stores which consist of "Ocean Terminal Hon" such as store "Ocean Terminal Hong Kong".
Is that even feasible within Excel?![]()
Bookmarks