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?

NEVER MIND, my fingers are faster then my brain. PROBLEM SOLVED thanks

possibly format the cell as Text.

--
Regards,
Tom Ogilvy

"HotRod" wrote in message
...
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?

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?

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

--
Regards,
Tom Ogilvy


"HotRod" wrote in message
...
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?