Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best way to add Multi selection box
I've been able to add Drop Down Lists and combo boxes that allow me to make
multiple selections BUT is it possible for them to show up as text in the cell so that they can be copied and pasted? What would be the best way to give my users 15 options and then have them select 5+ so that I can still copy and paste the data afterwards? THANKS IN ADVANCE |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best way to add Multi selection box
you can copy the contents of a combo box and paste it. but
i think you are wanting the combo box to be like a cell. sorry. combo boxes are individual objects sitting on top of the sheet. they are not part of the sheet itself. each object has it's own focus and only 1 object can have focus at a time. This means you would have to copy each combo box and paste it's content out on the sheet 1 at a time. then you could copy all. -----Original Message----- I've been able to add Drop Down Lists and combo boxes that allow me to make multiple selections BUT is it possible for them to show up as text in the cell so that they can be copied and pasted? What would be the best way to give my users 15 options and then have them select 5+ so that I can still copy and paste the data afterwards? THANKS IN ADVANCE . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best way to add Multi selection box
HotRod wrote:
I've been able to add Drop Down Lists and combo boxes that allow me to make multiple selections BUT is it possible for them to show up as text in the cell so that they can be copied and pasted? What would be the best way to give my users 15 options and then have them select 5+ so that I can still copy and paste the data afterwards? THANKS IN ADVANCE Add a new textbox, textbox1, to store the new data for selection. Add to the CHANGE event for the Combo Box userform1.textbox1.value=userform1.combobox1.value Gavin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi selection copy problem | Excel Discussion (Misc queries) | |||
Multi Selection List/Combi Box | Excel Discussion (Misc queries) | |||
Preventing Multi Cell Selection | Excel Discussion (Misc queries) | |||
Multi-selection problem in Excel XP and 2003 | Excel Discussion (Misc queries) | |||
multi tab selection prohibition | Excel Programming |