I'm trying to develop a code which can help me to create a dropdown list with auto-suggestion and auto-completion with the option being filtered in the list. eg. if it type 'a' then the dropdown list should show the result of all the options containing 'a' and once i type 'ab', the dropdown option should filter out automatically. The data is been fetched from the database and hence the range has to be dynamic and should be auto-updated in the dropdown list using VBA.

I have tried several code available on the web but something or the other is missing and have been stuck with the issue since long. The functionality works with the excel formulas but i need it via VBA.

Please Login or Register  to view this content.
Any kind of suggestion and solutions is appreciated.

Regards.

PS: I got the code from the web but don't know the author exactly so couldn't refer it. The code is quite functional but does not take the range into account as i need the flexible range in the dropdown list.