Adding a drop down list
 

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?

Adding a drop down list
 

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

Adding a drop down list
 

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?

Adding a drop down list
 

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?

Adding a drop down list
 

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?