Adding a drop down list

H

HotRod

OK this really isn't a programming question but to avoid adding another news
group. I've figured out how to add a drop down list to excel and populate
the list but how can I make it so that the cell with the drop down box is
treated like text for sorting, coping and reading into code?
 
H

HotRod

O.K instead of the first question can someone help with a COMBO BOX? In VB
when you have a combo box you can multiple selections, why can't I do this
in excel or if I can how do I do it? How can I give the user twenty options
and have them select five? Are there better ways to do this?
 
T

Tom Ogilvy

use an activex combobox from the control toolbox toolbar. Set the
multiselect property to true.
 
Top