See link for the file:https://www.dropbox.com/s/ta2yfrvgorw334v/VBA dynamic array.xlsm?dl=0
There is VBA code for dynamic dropdown in sheet "Entry", you can test it out and see how it works. I have two issues with it which I can't resolve:
1)The drilldown has empty spaces when you drill down any of dropdowns after the last item, can you help to remove the empty spaces from the end?
2)I want small improvement for the dropdown, namely, when I start typing values I want dropdown to dynamically only represent values which contain the text I enter in the dropdown cell. Similar to searching in google when it autopopulates results before you finish entering the search criteria.
Thanks
Rob
There is VBA code for dynamic dropdown in sheet "Entry", you can test it out and see how it works. I have two issues with it which I can't resolve:
1)The drilldown has empty spaces when you drill down any of dropdowns after the last item, can you help to remove the empty spaces from the end?
2)I want small improvement for the dropdown, namely, when I start typing values I want dropdown to dynamically only represent values which contain the text I enter in the dropdown cell. Similar to searching in google when it autopopulates results before you finish entering the search criteria.
Thanks
Rob
Last edited:
