Quote Originally Posted by Anshu View Post
...I've found an alternative way to fulfill my needs. Creating searchable and dependable drop down list may help, at least, to some extent. ........... it seems the nearest easy solution, as I think. .......
https://www.xelplus.com/searchable-drop-down-list/
https://www.contextures.com/xlDataVal02.html
Thanks for the follow up.
One small point to note: If I am not mistaken, that first reference is relying on the use of Dynamic Arrays. Dynamic Arrays are only available in newer Excel versions. If you develop something relying on Dynamic Arrays, then likely it will not work on earlier Excel versions

My personal feeling is that a lot of people will be using the earlier versions Of Excel well into the future. I have also seen many people going back to using earlier versions as main people are coming to the conclusion that newer versions introduce too many problems/ bugs that don’t offset any new features.
In fact most new features seem to be liked just by a minority of Microsoft Lovers, and IMO Microsoft have lost touch with their wider customer base.
So I would be wary of doing anything that only works in newer versions

I personally develop all my stuff , where possible in Excel 2003, and only then after try them in the versions 2007 – 2013, which are the versions I use the most.
I mostly use 2007 and 2010. I rarely use anything higher
Alan