isaacren94
New Member
- Joined
- May 18, 2019
- Messages
- 6
Hello I have a dynamic sheet that I am working on that requires a drop down list for multiple cells.
I have a table for each drop down list to make the main list searchable as demonstrated here https://www.extendoffice.com/documents/excel/2439-excel-drop-down-list-search.html.
The problem is that I have 46 drop down lists and while this method works it crashes constantly when I scale it up.
I keep getting error code '-2147417848 (80010108)': Method 'ListFillRange' of object 'IMdcCombo' failed
I am pretty sure this is because i have a private sub for each drop down box.
My question is could I create a module that would work for each drop down list?
I want to be able to search the drop down boxes since I have 400+ items for each.
Thanks for looking into my issue.
I have a table for each drop down list to make the main list searchable as demonstrated here https://www.extendoffice.com/documents/excel/2439-excel-drop-down-list-search.html.
The problem is that I have 46 drop down lists and while this method works it crashes constantly when I scale it up.
I keep getting error code '-2147417848 (80010108)': Method 'ListFillRange' of object 'IMdcCombo' failed
I am pretty sure this is because i have a private sub for each drop down box.
Code:
Private Sub ComboBox30_Change()ComboBox30.ListFillRange = "ddlll30"
Me.ComboBox30.DropDownMy question is could I create a module that would work for each drop down list?
I want to be able to search the drop down boxes since I have 400+ items for each.
Thanks for looking into my issue.
