Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I HAVE A 175 NAME DROP DOWNLIST.IN CELL IS SMALL.HOW CAN I ZOOM | New Users to Excel | |||
Changing Cell contents from formula to the actual result | Excel Discussion (Misc queries) | |||
how do i copy the actual text of a formula? | Excel Discussion (Misc queries) | |||
enlarge drop-down contents | Excel Discussion (Misc queries) | |||
Display actual contents of cell | Excel Discussion (Misc queries) |