I have a sheet where I need to have many drop-down boxes that have many options (i.e. 200+ options).
Each drop-down box is identical (i.e. it has the same lsit of things), but the drop-down box needs to be repeated many times so they can choose multiple options.
I'd also like for the user to be able to copy the drop-down list, and created more copies of the drop-down box as needed.
Finally, I want the user to be able to find items in the list easily by entering in beginning letters, i.e. they want to find "Orange", they can type in "or" and be brought near the word.
Right now I'm using Excel validation data lists and it accomplishes the "copyable" part of my requirements, but it doesn't let the user type in a few letters and be brought to a new part of the list.
It seems as though if I insert a "Forms.ComboBox" object, that it lets the user type in a few letters and be brought to a new part of the list, but it doesn't satisfy the "easily copyable" part of my requirements.
Any idea on how to get a drop-down list that is easy to copy and lets a user type in letters to get to a new part of the list?
Each drop-down box is identical (i.e. it has the same lsit of things), but the drop-down box needs to be repeated many times so they can choose multiple options.
I'd also like for the user to be able to copy the drop-down list, and created more copies of the drop-down box as needed.
Finally, I want the user to be able to find items in the list easily by entering in beginning letters, i.e. they want to find "Orange", they can type in "or" and be brought near the word.
Right now I'm using Excel validation data lists and it accomplishes the "copyable" part of my requirements, but it doesn't let the user type in a few letters and be brought to a new part of the list.
It seems as though if I insert a "Forms.ComboBox" object, that it lets the user type in a few letters and be brought to a new part of the list, but it doesn't satisfy the "easily copyable" part of my requirements.
Any idea on how to get a drop-down list that is easy to copy and lets a user type in letters to get to a new part of the list?
