Copy the actual contents of a drop downlist
 

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

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

Copy the actual contents of a drop downlist
 

ps. It depends on if you used a dropdown/combobox/data|validation cell or a
listbox (from the Forms toolbar or the control toolbox toolbar), too.

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

Copy the actual contents of a drop downlist
 

Not directly. To get a similar effect, you might try using the Data - Filter
- Advanced Filter, and only copy unique values.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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