Archive of Mr Excel Message Board


Back to Controls in Excel archive index
Back to archive home

Combo box

Posted by Frank O'Kelly on January 11, 2001 7:08 PM
Iwould love to find out how to put data into a drop down list or a combo box in excel 2000. I can put the item on the sheet but I am buggered if I can find a way to put a list into the drop down section.

Re: Combo box

Posted by Dave Hawley on January 11, 2001 10:13 PM


Hi Frank

If your Combo is from the Forms toolbar then:

Right click on you Combo and select "Format Control" then click the "Control Tab" now put you range that contains your list in the "Input range" box.


If from the Control Toolbox:

Right click on it and select "Properties" then Scroll down to "ListFillRange" and type your range, e.g A1:A100

You may want to consider using Data>Validation with "List" as your allowed entries.

Hope this helps

Dave


Re: Combo box

Posted by Paul Keetch on February 26, 2001 11:27 AM
I am also having problems with combo boxes. I can create one, insert list contents, but I would like to have the contents appear as a recurring option as the user passes each line down the worksheet. We are tracking call types (inbound, outbound, personal etc) in a call centre where the user manually completes a weekly worksheet.

I would also like to have these fields be reportable using a "=countif()" formula, which I can write, but can't seem to be able to apply to the selections in the combo boxes.

Any ideas first how to embed the combo into the cell, and then how to enable reporting on this data?

Help is much appreciated.

Paul


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.