Adding a drop down list

  • Thread starter Thread starter HotRod
  • Start date Start date
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?
 
NEVER MIND, my fingers are faster then my brain. PROBLEM SOLVED thanks
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to dynamically change the list in drop down list based on thevalue of another cell? 1
EXCEL DROP DOWN 2
Excel 2003: Help with Drop Down List 2
Pick from drop-down list gives empty or erroneous result 6
Drop Down List - Other Cell Results 5
Excel Excel: How do I put a formula in a drop down list 11
Colour-coding a cell from a drop down list 1
Define the Range of a drop-down list 5

Back
Top