Forum Discussion
VBA Dropdown, not working on older versions of excel
Mainly looking for What version of Excel is causing this issue and how to work around it. The VBA code pastes all the devices I need to a column on the "Dropdowns" sheet, then it uses the Sort, Uniqu...
This is a small part of a VBA program that is used to create the initial code and CAD files for Projects at the company I work for. Searching and creating the dropdowns manually via an add-in would add further steps for the user and overcomplicate a process that is intended to be as easy as possible,
Additionally the dropdown's information is somewhat dynamic, being built earlier in the code. As shown in the code I provided in the post "ModuleDrop" is the array of the variables needed for the dropdown. Then the "=SORT(UNIQUE(FILTER(XXXX)))" function is used to sort and create the list of items the dropdown refers to.
I'm trying to find what within this VBA process is causing issues in older versions of Excel? Then how to work around this issue while still using VBA
Additionally the dropdown's information is somewhat dynamic, being built earlier in the code. As shown in the code I provided in the post "ModuleDrop" is the array of the variables needed for the dropdown. Then the "=SORT(UNIQUE(FILTER(XXXX)))" function is used to sort and create the list of items the dropdown refers to.
I'm trying to find what within this VBA process is causing issues in older versions of Excel? Then how to work around this issue while still using VBA
Searching and creating the dropdowns manually via an add-in would add further steps for the user and overcomplicate a process that is intended to be as easy as possible,
The title is somewhat misleading. In reality, the add-in is not for creating data validation; rather, it is designed to automatically generate a searchable combobox based on existing data validation. The list in the combobox is sorted and unique.