MrExcel Publishing
Your One Stop for Excel Tips & Solutions

list boxes

Posted by oldlotusernewexceler on September 10, 2001 10:46 AM

How do I create list boxes in an excel document. I can create the box, but how do I create the selection options?

Posted by Russell Hauf on September 10, 2001 12:33 PM

What kind of selection options do you want? What exactly are you trying to accomplish?

Posted by exlotusernewexceler on September 10, 2001 8:31 PM

Maybe I'm completely on the wrong track!
I have a document that the user must input various things. At one place, I want the user to select from 2 alternatives. I can create two toggle buttons, but I prefer if there was a box with a pull down menu where the alternatives were listed. That way if there comes a 3rd altenative, I just add it to the pull down menu. I thought this was accomplished through a list box???

Posted by Russell Hauf on September 11, 2001 10:41 AM

If you want a pull-down, you should use a combo box. You can use one of the 2 different kinds:

One is from the Forms toolbar, and you must have the values (of which you say you currently have 2) in cells in the workbook. If you put your combobox on the worksheet, then right-click on it, you should see what it wants.

The other is from the Control Toolbox toolbar. This one is a bit more complicated.

Let me know if you still have trouble (maybe re-post or email me, I don't always look back down the list of postings).

Hope this helps,