Copy the actual contents of a drop downlist
Maybe...
But it'll depend on where the dropdown is (on a userform or on a worksheet).
And it'll depend on what you used to create the dropdown (data|validation, a
dropdown from the Forms toolbar or a combobox from the control toolbox toolbar).
If the dropdown uses a range as its list, it may be lots easier to just copy
that range.
Digi777 wrote:
Is there a way to copy just the contents of the drop down list (from a
filter for example). From the listbox itself?
Thx, D
--
Dave Peterson
|